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.