Excel Worksheet
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 |
Excel Worksheet
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 |
All times are GMT +1. The time now is 01:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com