Forum Discussion

RodL1966's avatar
RodL1966
Copper Contributor
Jul 09, 2018
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...
Formulas & Functions
Need Help
  • Haytham Amairah's avatar
    Haytham Amairah
    Jul 09, 2018

    Hi Rod,

     

    Please use this:

    =IF(OR(B24="",ISTEXT(B24)),"",IF((AND(B24>=92,B24<=99)),"Within Tolerance","Out of Tolerance"))

Manya Garg's avatar
Manya Garg
Icon for Microsoft rankMicrosoft
Jul 09, 2018

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

 

 

Resources