should I use IF function?
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
|