If & and
Try this:
=IF(AND(C2="",F2=""),"",H1-C2+F2)
HTH,
Elkar
"Peter" wrote:
Hi
I have credits in c2 and debits in f2 and the running total in h2 but I do
not want h2 to display anything if there is no number in either c2 or f2. I
have an idea it should look something like this
=If (c1 and f1="","",(h1-c2+f2)) but this does not work and I am not sure
about how to tie the IF & AND functions together to achieve my objective.
Any help would be gratefully received.
Peter
|