percentage formula

[Guest]

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.

 

[Ian]

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

 

[Guest]

Here is a way to enter the formula only one time:

1. say we have numbers in column A, from A1 thru A100
2. hi-light cells B1 thru B100
3. type =A1*(100-.25)
4. don't use ENTER to enter the formula in step 3, use CNTRL-ENTER

This should fill all the cells from B1 thru B100 in one swell foop!!

 

[Guest]

Gary's: 100-.25 = .75. Shorter. Isn't it?

Here is a way to enter the formula only one time:

1. say we have numbers in column A, from A1 thru A100
2. hi-light cells B1 thru B100
3. type =A1*(100-.25)
4. don't use ENTER to enter the formula in step 3, use CNTRL-ENTER

This should fill all the cells from B1 thru B100 in one swell foop!!

 

[Guest]

Gary's: Two quick ponits
1) It's eithr (1-.25) or (100-25)
2) (1-.25)=(.75)

 

[David Biddulph]

In general, 100-.25 would be 99.75, not .75, though I guess that the latter
was intended.
Maybe =A1*(100%-.25) or =A1*(1-25%) or ... ?

 

[Sandy Mann]

I assume that you mean 100%-25%=75%

100-.25 = 99.75

Also no individual cells can be altered in Gary's suggestion because that
are all part of an array.
--
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

 

[Guest]

It is not an array
CTRL + Enter <> CTRL + Shitf + Enter

 

[Guest]

Tevuna,David, & Sandy:

You are all correct. I goofed. Should have been:

3. type =A1*(1-.25)

 

[Stan Brown]

Sun, 19 Aug 2007 11:34:02 -0700 from James L

Heres what i would like to do. I would like column b to equal column a minus
x percent.

Please see answers in the other newsgroup where you posted, and in
future don't post the same query multiple times.