Can the TRUE be a blank cell instead?

[tlwarranties]

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

[#2 · Accepted 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)

[#3]

thank you so much!!!