If a cell A contains X then display cell B value - Please advise

Closed

Karthik - Feb 29, 2016 at 07:40 AM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Mar 4, 2016 at 09:32 PM

Hello Everyone,

How to get the cell B value when Call A1 is X the display what ever is there in Cell B1 as in Cell C. If not the leave the column blank or 0.

Please help me out resolving this.

I appreciate your help on this matter

Thanks,
Karthik

If a cell A contains X then display cell B value - Please advise
Count if cell contains number - Excel Forum
If cell contains date then return value ✓ - Office Software Forum
Cell phone codes - Guide
Excel cell color formula - Guide
Excel formula to check if cell contains a date - Excel Forum

1 response

Answer 1 / 1

BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 149
Mar 4, 2016 at 09:32 PM

Hi Karthik,

Im not quite sure what you want, but putting the following code into cell B1 will display cell C1 only when cell A1 is "x"

=IF(A1="x",C1)

Similar discussions

help me to add particular cells

If a cell contains any text then add a value

If cell A1 has text then cell B2 has today's Date

How to use conditional format based on text?

Excel - IF function with multiple words

Similar discussions

Subscribe To Our Newsletter!