Invoice formula help to read zero if blank

[RayBox]

Hi All,

I'm putting together an invoice form that has columns for Part #, Description, Quantity, Each price and total with about 10 rows. The total column is a basic formula of Quantity multiplied by the Each price. Eg E2=C2*D2 Currently if the Quantity & Each price columns are blank the formula still puts a zero in the total column.

Can anyone suggest a change to the formula so that the total column is blank if the Quantity & each price columns in that row are empty?

Basically don't want a total column full of zero's.

Thanks in advance for any help.

Ray

[khamilton]

maybe this is what your looking for? =if(C2*D2=0,"",C2*D2)

[RayBox]

Fantastic! Problem solved. Thanks heaps.