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
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
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
Related:
- If a cell A contains X then display cell B value - Please advise
- If cell contains date then return value - Excel Forum
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
- Count if cell contains number - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
1 response
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
149
Mar 4, 2016 at 09:32 PM
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"
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)
