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
Related:
- If a cell A contains X then display cell B value - Please advise
- If cell contains date then return value - Excel Forum
- Count if cell contains number - Excel Forum
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - 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)
