jcontrer

I finished reading your post!!! In your formula you are making reference to
A100 that is fixed (not incrementing). Because your formula is incrementing
as you drag it you are loosing that reference, and picking up references on
down column A that are empty. If you give the #div/0! error it is because
you can not divide a number by nothing (or zero) and get an answer. This
error is telling you there is no number to divide by. Look in Help to learn
the difference between absolute & relative references. What you need to do
is use $A$100 in your formula. This will hold the reference to A100 all the
way down you column B.

Hope this helps

Mike Rogers
"jcontrer" wrote:

i have numerical data on column a. It consists of a list of about 100
numberswith a total on the last row of the column a. on column b i want the
percentage of of the total in column a that each corresponding row
represents. i tried using the fill handle by inputting the formula in the
first few rows of b (eg. b2 =a2/a100, b3 =a3/a100) and then tried to
highlight both and use the fill handle to get the rest of the column and not
have to input one by one but i get an error #div/0! for all of column b after
the first 2 rows.

What is wrong and how can it be fixed?
--
thanks in advance