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

[Closed]
Report
-
Posts
1004
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 27, 2020
-
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

1 reply

Posts
1004
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 27, 2020
140
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)