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

=IF(AND(ISBLANK(H7),ISBLANK(I7),"",J7-H7+I7)
--
Brevity is the soul of wit.


"cmccurdy23" wrote:

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

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...

"Dave F" wrote:

=IF(AND(ISBLANK(H7),ISBLANK(I7),"",J7-H7+I7)
--
Brevity is the soul of wit.


"cmccurdy23" wrote:

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