Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I subtract 20% from a column of prices?
I am trying to line up different prices with percentages taken out for
discounts. I would like to list these side by side in different columns. How would I tell the rows to subtract 20% off of the price and list it in the column next to it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I subtract 20% from a column of prices?
Assuming the prices are in column A
In B1 enter =A1*.8 Double-click on the fill handle of B1 to copy down. On Sat, 8 Dec 2007 19:18:00 -0800, mlhank wrote: I am trying to line up different prices with percentages taken out for discounts. I would like to list these side by side in different columns. How would I tell the rows to subtract 20% off of the price and list it in the column next to it? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I subtract 20% from a column of prices?
With Prices in A2:A100
Try this: B1: (a discount percent.....eg 20%) This formula returns the Col_A Price less B1 (20%) B2: =$A2*(1-B$1) Copy that formula down through B100 Note: You can enter other discount percents across Row_1 and copy the formulas across. Example: C1: 12% Copy the Col_B formulas into Col_C Is that something you can work with? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "mlhank" wrote in message ... I am trying to line up different prices with percentages taken out for discounts. I would like to list these side by side in different columns. How would I tell the rows to subtract 20% off of the price and list it in the column next to it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add $1 to 3500 prices in 1 column: Excell 2003 | New Users to Excel | |||
Want to change current prices in a column by a percentage | Excel Worksheet Functions | |||
Applying a discount to a column of prices! | Excel Discussion (Misc queries) | |||
Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions | |||
Need to add a certain percentage to a column of prices | Excel Worksheet Functions |