Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert a 10% discount on a spreadsheet
I have an original spreadsheet with pricing. Now I need to save this with a
10% discount and 15% discount etc.... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert a 10% discount on a spreadsheet
=A1*(1-10%)
where A1 holds the original value if you want to do it without formulas, copy the values toa new sheet (right click sheet tab and select move or copy, then check copy now put 0.9 in an empty cell, copy it, select the newly cretaed values and do editpaste special and check multiply do the same for 15% but use 0.85 instead -- Regards, Peo Sjoblom "Bridget Nelson" <Bridget wrote in message ... I have an original spreadsheet with pricing. Now I need to save this with a 10% discount and 15% discount etc.... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert a 10% discount on a spreadsheet
More specifics would help... do you want to just replace every price shown
with a value that's 90% as much? Or is this a variable you need to set so that you can adjust as needed? I'll assume the latter (since it will get you the former)... Pick two cells, one to be a label, one the value. For argument's sake, I'll assume they're in A1 and B1. Enter the word Discount in A1 and 90% in B1. Highlight both cells and Insert Name Define. Ensure that Excel is creating the name Discount and that it references B1. Now we need to apply the discount to your prices. I'll assume your existing prices are in column B (with a product codes in column A), starting in row 4. In c4, enter the equation =B4 * (1-Discount). The result should reflect the discount applied to the old price. Autofill that formula by placing the cursor over the lower right corner (it's called the fill handle); you'll see the cursor change shape. Double-click and it should fill the column. Note that if you change the discount in B2, all the prices in column C will change in step. Hope this is roughly what you were looking for. If not, please be as specific as you can about what the output(s) should be. "Bridget Nelson" wrote: I have an original spreadsheet with pricing. Now I need to save this with a 10% discount and 15% discount etc.... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert a 10% discount on a spreadsheet
do editpaste special and check multiply
May I suggest a slight modification: EditPasteSpecial select "Values" AND "Multiply", then OK Otherwise you will change any pre-existing formatting in the area being pasted over with whatever format your "empty" cell had. (Or adjust the format of the "empty" cell before copying it, and then you don't need to worry about selecting "Values") HTH, -- George Nicholson Remove 'Junk' from return address. "Peo Sjoblom" wrote in message ... =A1*(1-10%) where A1 holds the original value if you want to do it without formulas, copy the values toa new sheet (right click sheet tab and select move or copy, then check copy now put 0.9 in an empty cell, copy it, select the newly cretaed values and do editpaste special and check multiply do the same for 15% but use 0.85 instead -- Regards, Peo Sjoblom "Bridget Nelson" <Bridget wrote in message ... I have an original spreadsheet with pricing. Now I need to save this with a 10% discount and 15% discount etc.... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert a 10% discount on a spreadsheet
Good point
-- Regards, Peo Sjoblom (No private emails please) -- Regards, Peo Sjoblom (No private emails please) "George Nicholson" wrote in message ... do editpaste special and check multiply May I suggest a slight modification: EditPasteSpecial select "Values" AND "Multiply", then OK Otherwise you will change any pre-existing formatting in the area being pasted over with whatever format your "empty" cell had. (Or adjust the format of the "empty" cell before copying it, and then you don't need to worry about selecting "Values") HTH, -- George Nicholson Remove 'Junk' from return address. "Peo Sjoblom" wrote in message ... =A1*(1-10%) where A1 holds the original value if you want to do it without formulas, copy the values toa new sheet (right click sheet tab and select move or copy, then check copy now put 0.9 in an empty cell, copy it, select the newly cretaed values and do editpaste special and check multiply do the same for 15% but use 0.85 instead -- Regards, Peo Sjoblom "Bridget Nelson" <Bridget wrote in message ... I have an original spreadsheet with pricing. Now I need to save this with a 10% discount and 15% discount etc.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to replicate insertting a row from 1 worksheet into another | Excel Discussion (Misc queries) | |||
Mirror spreadsheet? | Excel Discussion (Misc queries) | |||
Spreadsheet Dilemma | Excel Discussion (Misc queries) | |||
paste contents from other spreadsheet | Excel Worksheet Functions | |||
Challenging Charting | Charts and Charting in Excel |