| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional change to absolute
I am running a slope profile in excel, need to update the formula to change
the referenced address to the new elevation value (absolute reference) of the value in the same row when the update trigger occurs, and hold that value in the formula until the next update is triggered, then change it to the value in that row, etc. Is there a function I can place in an IF statement that will do this? Thanks, cob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I do conditional formatting for absolute values? | Excel Worksheet Functions | |||
| Conditional Formatting with absolute references | Excel Worksheet Functions | |||
| Absolute Reference to the Left Until Change in Row | Excel Worksheet Functions | |||
| HOW DO I CHANGE A FORMULA INTO AN ABSOLUTE NUMBER? | Excel Discussion (Misc queries) | |||
| Absolute Path change ... | Excel Discussion (Misc queries) | |||
Threaded Mode
