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"))

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jul 09, 2018

Hi Rod,

 

Please use this:

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

  • RodL1966's avatar
    RodL1966
    Copper Contributor
    Jul 09, 2018
    Hello Haytham,

    That worked like a charm, thank you very much.