Calculating amount after subtracting percent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top