should I use IF function?

C

cmccurdy23

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
 
C

cmccurdy23

Thank you! II tried so many things...I knew it could be done, I've done it
before. But it's been a long time since I've used Excel extensively. Now I
just need to recall all the other things I used a long time ago...
 
Top