Forum Discussion
Solved
Leave adjacent cell blank if formula cell is blank
Good day Excel Gurus!
I have the following formula in a cell I've titled "Status":
=IF((AND(B24>=92,B24<=99)),"Within Tolerance","Out of Tolerance")
To finish it I want the "Status" cell to be blank unless the criteria of the formula creates one of the two responses. I know it's probably very simple, but I am stumped on getting it to work.
Thank you in advance!
Hi Rod,
Please use this:
=IF(OR(B24="",ISTEXT(B24)),"",IF((AND(B24>=92,B24<=99)),"Within Tolerance","Out of Tolerance"))
3 Replies
Manya GargMicrosoft
Rod,
You can also try:
=IF(ISNUMBER(B24), IF((AND(B24>=92,B24<=99)),"Within Tolerance","Out of Tolerance"), "")
That will cover everything in case the value is not a number including spaces, text, errors etc
Hi Rod,
Please use this:
=IF(OR(B24="",ISTEXT(B24)),"",IF((AND(B24>=92,B24<=99)),"Within Tolerance","Out of Tolerance"))
- Hello Haytham,
That worked like a charm, thank you very much.
