percentage formula
Gary's: Two quick ponits
1) It's eithr (1-.25) or (100-25)
2) (1-.25)=(.75)
"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.
|