simple sum question

[smiley61799]

I am using the sum feature on a large spreadsheet where one total might not
be complete and yields a #VALUE!. Is there a way to make this appear 0. I
am using a simple =A13*G13 formula. Any help is greatly aprpeciated.

 

[Kassie]

You can use
=IF(ISERROR(A13*G13,0,A13*G13)

--
HTH

Kassie

Replace xxx with hotmail