Ecel Questions - Adding cells together ???

[AlP]

Good morning all,

Here is what I am stuck on. On cell A1=3 & Cell A3=2. If I add cell A1, A2 & A3 to show on cell B1, but on cell A2 is shows a #N/A, is there a way to let the program know to treat cell A2 as a 0. so the end result in cell B1 = 5.

Please help.

Thanks,
ALp

[MattShoreson]

=a1+if(isna(a2),0,a2)+a3

[AlP]

thank you very much for the info. It really does help me on this problem.

Alp