IF works - nearly!

Joe · Mar 23, 2004

The formula below works ok, except when I enter 0 (or
leave blank} in C2 nothing is returned in E2 (the result
cell). If I enter an amount >1 in C2 a result is returned
in cell E2. I am trying to keep a continuing balance
which is blank if no amounts are in cols C and D.

IF(C2=0,E1-C2+D2,"")

Can anyone help please?

Joe

Frank Kabel · Mar 23, 2004

Hi Joe
try
IF(AND(C2<>"",D2<>""),E1-C2+D2,"")

Guest · Mar 23, 2004

Hi Frank
It works! Thanks a million.
Joe

-----Original Message-----
Hi Joe
try
IF(AND(C2<>"",D2<>""),E1-C2+D2,"")

--
Regards
Frank Kabel
Frankfurt, Germany

.

IF works - nearly!

Joe

Frank Kabel

Guest