Tevuna,David, & Sandy:

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

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


--
Gary''s Student - gsnu200738


"Sandy Mann" wrote:


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


Replace @mailinator.com with @tiscali.co.uk


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