assumed Cell A2 has price
Cell B2 has 60% , C2 has 40 % in D2 put this formula & drag it down

=A2-(A2*$B$2) ( Price - (%value on price))

suppose u have price 100 and it changes from time to time.
Is the percentage remains same as 60 % & 40 % ( i guess these are
estimated )

is this what you are looking for ?



On Nov 18, 11:20*am, MAGIC wrote:
I have several columns, all with different values. I would like to know if
there is a formula I can use for the entire column, or do I have to put in
the formula for each cell. *Each column is going to do the same thing,
although with a different set a numbers: example
price * * 60% * * *40% * * * * * subtract this amount from original price
* *? * * * * ? * * * * * ? * * * * * * * * * * * * ?
the price will vary, and the amount to subtract will vary, but I have
several pages to do and would rather not put the formula in each cell. *I
will get out mu calculater first.
--
thanks so much
magic