Originally Posted by
dflak
The formula you have references column C. The formula is expecting to have a numeric value in this cell. However, sometimes you have the null string.
You can change this formula: =IF(F9>0,B9-F9,"")
to: =IF(F9>0,B9-F9,0)
or wrap the whole big formula in an if statement checking F9 or wrap it in IFERROR().
Bookmarks