| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert Row - Stop Automatic Formula Update
I have a formula in cell C5 that displays the percent change between two
values in the same column. The formula reads =-(C10-C9)/C10. When I insert a in row 8, the row numbers in the formula in cell C5 automatically increase by one to reflect the new cells =-(C11-C10)/C11. When I insert a row I want the formula to keep analizing the newly formed cells, instead of automatically updating the formula so that the original cells are used. Any help would be greatly appreciated |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert Row - Stop Automatic Formula Update
=-($C$10-$C$9)/$C$10
"Kevin" wrote: I have a formula in cell C5 that displays the percent change between two values in the same column. The formula reads =-(C10-C9)/C10. When I insert a in row 8, the row numbers in the formula in cell C5 automatically increase by one to reflect the new cells =-(C11-C10)/C11. When I insert a row I want the formula to keep analizing the newly formed cells, instead of automatically updating the formula so that the original cells are used. Any help would be greatly appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
| Stop cell reference in formula changing when insert column? | Excel Discussion (Misc queries) | |||
| Automatic update formula when worksheet 1 move to another excel fi | Excel Discussion (Misc queries) | |||
| How to stop Automatic calculations? | Excel Discussion (Misc queries) | |||
| Stop Insert Row modifying formula data | Excel Discussion (Misc queries) | |||
Linear Mode
