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