Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating amount after subtracting percent
Heres what i would like to do. I would like column b to equal column a minus
x percent and appear in column c. The goal is to only have to eneter one formula and it will automatically fill it in to the corresponding row. EX. A B 200 150 100 75 400 100 Is there a way to do this with out entering the fomula in to every row. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating amount after subtracting percent
Not a formula that will automatically fill in the rows but you can drag the
formula down but using the fill handle, the little box in the bottom right-hand corner of the cell. When you hover the cursor over it, the big white cross will turn into black crosshairs. When it does, left-click and hold as you drag the cursor down the column. If Column A already has the data fill in then double left-clicking on the fill handle will fill in the formulas down as fa as the data goes. Another way is to highlight the column including the first cell with the formula and select Edit Fill Down. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "James L" <James wrote in message ... Heres what i would like to do. I would like column b to equal column a minus x percent and appear in column c. The goal is to only have to eneter one formula and it will automatically fill it in to the corresponding row. EX. A B 200 150 100 75 400 100 Is there a way to do this with out entering the fomula in to every row. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PIVOT TABLES-PERCENT/AMOUNT OF CHANGE | Excel Worksheet Functions | |||
Calculating Interest Amount | Excel Worksheet Functions | |||
Problem calculating percent change | Excel Worksheet Functions | |||
Calculating percent off a single cell | Excel Discussion (Misc queries) | |||
Calculating a aariable amount or row | Excel Discussion (Misc queries) |