simple sum question
 

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.

simple sum question
 

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

--
HTH

Kassie

Replace xxx with hotmail


"smiley61799" wrote:

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.