percentage formula
Hi James
The example you give has B equal to different percentages. The easiest way
with this would be to have another column with the percentage values (eg
column D).
In the first row of data in column B, type =A2*D2/100 then copy it down the
column as far as you need. The references to row 2 will change to 3, 4 etc.
Type the percentages in column D (eg 75, 75, 25 in your example)
If the 3rd row of your example is a type and they are all 75%, the formula
is =A2*0.75
--
Ian
--
"James L" wrote in message
...
Heres what i would like to do. I would like column b to equal column a
minus
x percent. 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.
|