Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
qick help please about fill handle
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
qick help please about fill handle
jconter,
in your formulas, your cell references are "relative". That means when you copy down or accross, the cell refferences will change accordingly. "Absolute" cell references will not change when you copy down/accross. Also, in your cell reference, the column can be absolute, the row can be absolute or both can be absolulte. To make a reference absoulute, place a $ before the column, row, or both. In your formula, you will want to make A100 absolute.......at least the row "=A2/A$100", but maybe both row & column "=A2/$A$100". Then you only need to select the first cell (you don't need to select 2) and fill down as necessary. HTH, Conan "jcontrer" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
qick help please about fill handle
jcontrer
select the cell with the formula in column B and move your curser to the bottom right side of the border on that cell.. you should see your curser change form a large white Plus sign to a small black plus sign. Once you have that small plus sign just double click and your formulas will fill to the bottom of the data in column A. If by chabce that does not work for you once you get that small black plus sign drag that all the way down to the bottom of your data. There are still more ways of getting what you want but these are the ones that I use frequently. 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
qick help please about fill handle
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Handle | Excel Discussion (Misc queries) | |||
fill handle | Excel Discussion (Misc queries) | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
fill handle | Excel Discussion (Misc queries) | |||
fill handle | Excel Discussion (Misc queries) |