SOLVED

Can the TRUE be a blank cell instead?

Occasional Contributor

Hello,

 

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

 

tlwarranties_0-1663784460431.png

 

 

Thank you,

Tara

2 Replies
best response confirmed by tlwarranties (Occasional Contributor)
Solution

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

thank you so much!!!