Hi,

Cell A1=5
Cell A2=5
Cell A3=if(sum(A1+A2)=0,"",sum(A1+A2)) ----- will return 10 or
""(Blank)
Cell A4=10

Cell A5=sum(A3+A4) ------should return 20 or 10 or 0

Now here is the error: If there is no value in the Cell A1 & A2 I get
error(#value) in the Cell A5 becuase I have put ""(Blank) in the
formula which is there in the A3. I tried different formats but they
are not working. I never faced such error in excel 2003.

Regards

Heera