| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
