This is a direct ripoff of Microsoft's checkbook register…. =IF(AND(ISBLANK(F8),ISBLANK(G8)),"",H7-F8+G8) …. If the reference cells are blank until used, the cell with the formula will remain blank. Dude is right that because you get #### is a column width pro... Login to read more.