Excel Worksheet

[MAGIC]

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.

 

[muddan madhu]

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 ?