Formu;a Reading Zero Possible to read blank

Hey guys,

Is it possible for a sum formula to read nothing when the sum is zero. So if the sum is zero instead of it reading 0 I just want nothing there at all?

Thanks,

CW

You can do this:

=IF(SUM(range)=0,"",SUM(range))

Hope this helps.

Pete

I'm sorry I was mistaken it wasnt a sum formula i'm working with well on one worksheet it is on the other I need something ike this =IF(SUM(C9:C12=0),"",(((C9*C10)*2)/144)*C11*C12) but i only get a #Value Any suggestions.

Thanks,

CW

It depends what values you have in those cell C9 to C12 - perhaps one or more of them contain a text value that looks like a number (or ""). You could do this to avoid the error:

=IF(SUM(C9:C12=0),"",IFERROR(C9*C10*2/144*C11*C12,""))

Hope this helps.

Pete

Well It is just numbers panel sizes 18 x 24 x 2 x 144 x 2 x 1.3. See i'm calculating mil/ft of resist processed which is a film that goes a a circuit board i've attached a file. I want it to calculate the calculation I had if there are numbers there if there are not number I want it to be blank. Third worksheet in file is what i'm referencing.

Much Thanks,

CW

Perfect Thank you!