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 ... ?
--
David Biddulph

"Tevuna" wrote in message
...
Gary's: 100-.25 = .75. Shorter. Isn't it?

"Gary''s Student" wrote:

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!!
--
Gary''s Student - gsnu200738


"James L" wrote:

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.