Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare excel worksheet and output difference to new worksheet | Excel Discussion (Misc queries) | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Linking Formulas, Worksheet to Worksheet - Excel 2003 | Excel Discussion (Misc queries) | |||
How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions |