software

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

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

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

=if(a2 = quot;quot;, quot;quot;, a2 b2)

--
Kevin Vaughnquot;Gerdquot; wrote:

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

quot;Gerdquot; wrote:
gt; I have column A with Prices; column B contains formula
gt; - Price x 0.05; column C contains formula - sum of Col A
gt; and Col B. [....]
gt; Is there any way that I can modify the formulas so that
gt; when there is no price in column A that nothing will show
gt; up in columns B and C.

I don't know of an easy way (e.g, a Calculation option).
But you could put the following formulas in col B and C:

B1: =if(isblank(A1),quot;quot;,0.05*A1)
C1: =if(isblank(A1),quot;quot;,A1 B1)

goto tools,option,view,uncheck zero values