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
- Conditional formatting if cell contains text - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
1 response
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
150
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)
