You can test for the absence of data in column A and return "" (nothing.)
In B for instance, try something like =if(a2 = "", "", a2 * .05)
and in C, maybe =if(a2 = "", "", sum(a2:b2))

then again, you could use a2 + b2 rather than sum since you are just adding
2 columns.

=if(a2 = "", "", a2 + b2)

--
Kevin Vaughn


"Gerd" wrote:

I have column A with Prices; column B contains formula - Price x 0.05; column
C contains formula - sum of Col A and Col B. When I drag these formulas down
the rows that do not contain any data in col A show $ -
Is there any way that I can modify the formulas so that when there is no
price in column A that nothing will show up in columns B and C.
Thank you very much for any help.

Gerd