Gord Dibben wrote:
Just copy the formula down from C3 as far as you wish.

Grab the fill handle of C3 and drag down.

The fill handle is the little blank lump you see at bottom right corner of the
cell.

Left-click on that and drag.

In case there are no numbers yet in column C enter this in D3.

=IF(ISNUMBER(C3),C3*5%,"")

You are still stating that .05 percent of 100 is 5 which is incorrect.

5% of 100 is 5

One way:

[quoted text clipped - 17 lines]
"C" in each of these 15 rows, I would want the formula of 5% to appear in
column "D".


I did as instructed and it worked. Thanks 1,000,000!!! One thing I noticed
was that the $ sign and .00 cents do not show in column "C" when I type in 55.
00. However the cents .00 do show in column "D". How do I get the $ sign
and the .00 cents to appear in column "C" when I type it?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1