I'm guessing that because no one has responded to you for some 2+ hours,
they all are having the same problem understanding your question that I am.
None of us are sure what you mean when you say you are "running a slope
profile", so that doesn't help us understand the rest of your request; and
saying you need to upgrade "the formula" without showing us the formula
doesn't clarify anything for us either. Perhaps if you showed us an example
of your "before" data, the formula you now have and what you want your
"after" data to look like, someone might be able to help you out. The more
information you give us about what you are working with, the better able we
will be to figure out what you are trying to do.

Rick


"COB" wrote in message
...
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