| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Markups
I would like to know if it is possible to apply a 'blanket' markup on
existing cell definitions across an entire spreadsheet. I already have the figures, how do I add 15% to them all? Is there a simple way to do this or do I have to apply a calculation to each cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Markups
This must be a homework problem
See my answer to same question today on this newsgroup "Question on how to raise a price 15% in a coloum" -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Wackman" wrote in message ... I would like to know if it is possible to apply a 'blanket' markup on existing cell definitions across an entire spreadsheet. I already have the figures, how do I add 15% to them all? Is there a simple way to do this or do I have to apply a calculation to each cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Markups
Thanks - such a simple solution, just the way I like it.
"Bernard Liengme" wrote: This must be a homework problem See my answer to same question today on this newsgroup "Question on how to raise a price 15% in a coloum" -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Wackman" wrote in message ... I would like to know if it is possible to apply a 'blanket' markup on existing cell definitions across an entire spreadsheet. I already have the figures, how do I add 15% to them all? Is there a simple way to do this or do I have to apply a calculation to each cell? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Markups
Enter 1.15 in an unused cell.
Copy that cell. Select your range of prices and EditPaste SpecialMultiplyOKEsc Clear the cell with 1.15 Gord Dibben MS Excel MVP On Thu, 15 Nov 2007 07:35:01 -0800, Wackman wrote: I would like to know if it is possible to apply a 'blanket' markup on existing cell definitions across an entire spreadsheet. I already have the figures, how do I add 15% to them all? Is there a simple way to do this or do I have to apply a calculation to each cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
| Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
| cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Hybrid Mode
