| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DECREASE CELL VALUES BY 50%
I have either entered data and performed calculations on the amounts entered
in most cells in my workbook to come up with a budget for the year. I want to decrease the total by say $100,000 and see what the data entry figures would need to be to come up with the revised total. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
DECREASE CELL VALUES BY 50%
--Enter 2 in a unused cell and copy the cell
--keeping the copy Select the data range (values which are to be converted) --Right clickPasteSpecialselect DivideOK If this post helps click Yes --------------- Jacob Skaria "Sandra Dryden" wrote: I have either entered data and performed calculations on the amounts entered in most cells in my workbook to come up with a budget for the year. I want to decrease the total by say $100,000 and see what the data entry figures would need to be to come up with the revised total. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
DECREASE CELL VALUES BY 50%
OMG --- too easy. Thanks so much
"Jacob Skaria" wrote: --Enter 2 in a unused cell and copy the cell --keeping the copy Select the data range (values which are to be converted) --Right clickPasteSpecialselect DivideOK If this post helps click Yes --------------- Jacob Skaria "Sandra Dryden" wrote: I have either entered data and performed calculations on the amounts entered in most cells in my workbook to come up with a budget for the year. I want to decrease the total by say $100,000 and see what the data entry figures would need to be to come up with the revised total. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mouse click to increase/decrease a cell value? | Excel Discussion (Misc queries) | |||
| create up and down arrows to increase and decrease value in a cell | Excel Worksheet Functions | |||
| Decrease Decimal in a combined text/formula cell | Excel Worksheet Functions | |||
| Decrease Decimal in a combined text/formula cell | Excel Worksheet Functions | |||
| How do I set a cell that can increase but never decrease? | Excel Discussion (Misc queries) | |||
Linear Mode
