I am trying to balance a worksheet, but I do not want #VALUE! to appear for
data that I have not yet entered.

Column H is Debits
Column I is Credits
Column J is balance (initial balance($J7) - H +I).....

I want to be able to have my function in all of the cells in column J, but I
want J to be blank when I have not yet entered data in H and I.... I tried
using IF, but I do not know if I can use it for bith H and I at the same
time. So, if H is "" and I is "" then "" otherwise (initial balance($J7) - I
+ J)

Thanks