If a cell A contains X then display cell B value - Please advise
Closed
Karthik
-
29 Feb 2016 à 07:40
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 - 4 Mar 2016 à 21:32
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 - 4 Mar 2016 à 21:32
Related:
- If a cell A contains X then display cell B value - Please advise
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- How to delete a cell in word - Guide
- What function can automatically return the value in cell c77 - Excel Forum
- Excel multiple lines in one cell - Guide
1 response
BrianGreen
Posts
1005
Registration date
Saturday 17 January 2015
Status
Contributor
Last seen
30 September 2021
149
4 Mar 2016 à 21:32
4 Mar 2016 à 21:32
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)
