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
- Conditional formatting if cell contains text - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
- Count if cell contains number - Excel Forum
- Based on the cell values in cells b77 ✓ - 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)
