| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with adding 10%
We have put our prices sheets in excel. Is there a forumal that I can type in
that will increase every price by 10% because we have had a price increase? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with adding 10%
=A1*1.1 and copy down
or put 1.1 in a spare cell, copy, select your prices, paste special/ multiply. -- David Biddulph "Jennifer" <Jennifer @discussions.microsoft.com wrote in message ... We have put our prices sheets in excel. Is there a forumal that I can type in that will increase every price by 10% because we have had a price increase? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with adding 10%
Enter 1.1 in an empty cell.
Copy it. Select the column that contains the prices. Select paste-special--multiply and click OK. Dave -- Brevity is the soul of wit. "Jennifer" wrote: We have put our prices sheets in excel. Is there a forumal that I can type in that will increase every price by 10% because we have had a price increase? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| building YTD figures by adding to a previous months total | Excel Discussion (Misc queries) | |||
| Please help with adding automatic data. | Excel Discussion (Misc queries) | |||
| Rounding Error when adding or subtracting two cells | Excel Worksheet Functions | |||
| adding vertical bars to an embedded chart using VBA | Excel Discussion (Misc queries) | |||
| help neede with adding times | Excel Discussion (Misc queries) | |||
Linear Mode
