| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change a number in one cell to change a series of cells?
How do I change a series of numbers in cells by only replacing one number in
a cell? Currently, I want to increase a series of cells 4% and I used the formula =M50*(1-$P$1). However, I have to use 204% to get a 4% increase and then it is a negative number. What formula should I be using so when I change the single cell it either increases 4% or when using 0 it changes to the original cell number. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
| CELLS HAVING SAME NUMBER BY CHANGING ANY CELL | Excel Discussion (Misc queries) | |||
| how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) | |||
Threaded Mode
