| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Automate simple calculation/formula
Does anyone know how to automate this process. I want to insert a new row 10
and when I do this I want the formula that is in row 9 to stay the same but it will recognize the new row 10 and the new row 11 in the formula and keep the formula =A10/A11-1. I think this should be easy but my brain can't think. Thanks. Row 9 is % growth =A10/A11-1 formula Row 10 5000 Row 11 1000 AFTER INSERTION OF ROW ------------------------------------------- Row 9 is % growth =A10/A11-1 new formula Insert New Row 10 7000 Row 10 5000 Row 11 $1,000 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automate creation of sheets in excel | Excel Worksheet Functions | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Help with what should be a simple formula | Excel Worksheet Functions | |||
| Simple But Stumped | Excel Discussion (Misc queries) | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Linear Mode
