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 Contributor 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
How to delete a cell in word - Guide
Activate cell - Excel Forum
Excel multiple lines in one cell - Guide
Conditional formatting if cell contains text ✓ - Excel Forum
Best cell phone 2023 - Home - Buying guides

1 response

Answer 1 / 1

BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Contributor 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

If a cell contains any text then add a value

Clear cell contents based on value of another cell range using VBA

help me to add particular cells

Highlight cell if another cell contains specific text

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

Similar discussions

Subscribe To Our Newsletter!