Feb 09 2022 02:06 PM
I have many different cells that formulate simple equations on my spread sheet. I would like for three of them to not formulate without another cell being marked X or x. How would I do this?
Feb 09 2022 02:17 PM
SolutionLet's say you now have
=formula
and that you want the cell with this formula to look blank if C2 does not contain "x" or "X". Change the formula to
=IF(UPPER(C2)="X", formula, "")
Feb 09 2022 02:17 PM
SolutionLet's say you now have
=formula
and that you want the cell with this formula to look blank if C2 does not contain "x" or "X". Change the formula to
=IF(UPPER(C2)="X", formula, "")