Forum Discussion

tlwarranties's avatar
tlwarranties
Copper Contributor
Sep 21, 2022
Solved

Can the TRUE be a blank cell instead?

Hello,

 

I have this formula which is putting TRUE in all my cells, and I would like for those cells to be blank instead.

 

 

 

Thank you,

Tara

excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Sep 21, 2022

    tlwarranties Your formula checks if B10 is empty. If so it returns the result from F10="", which it either TRUE or FALSE. If F10 is not empty it will calculate H9-B10-F10.

     

    If you want the result to be a blank if B10 is empty use this:

    =IF(B10="","",H9-B10-F10)

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Sep 21, 2022

    tlwarranties Your formula checks if B10 is empty. If so it returns the result from F10="", which it either TRUE or FALSE. If F10 is not empty it will calculate H9-B10-F10.

     

    If you want the result to be a blank if B10 is empty use this:

    =IF(B10="","",H9-B10-F10)

Resources