Hiding Formulas
Assuming quantity is in column A and unit price in column B, one way:
C1: =IF(COUNT(B1:C1)<2,"",B1*C1)
In article ,
"jdy" wrote:
I have a total column of a quote form that multiplies the
quantity column X the unit price column. It works fine
except that each of the total column rows says that are
blank say "#value" in each of them. I would like for the
total column to be blank except for the rows that have
product entries in them. Thanks for the help in advance.
|