Forum Discussion
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
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)
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!!!