conditional change to absolute

[COB]

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

 

[Rick Rothstein \(MVP - VB\)]

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]

Right, sorry. So, I want to calculate a series of slopes given the elevation
point data and station points which are equidistant (say, 5 feet apart). I
have several IF statements (let's say just one for simplicity) and would like
the base elevation to change to an absolute reference to the elevation value
in the row in which the condition is met and carry forward until the next
condition is met, update again, etc.
A B C D E F
rastrnd CUMDX SLOPE WBPLGrdChg WB40 1
540.750 0 0 0 0 2
540.739 1.524 -0.720 99999 FALSE 3
540.735 3.048 -0.502 99999 FALSE 4
540.737 4.572 -0.299 1 FALSE 5
540.738 6.096 0.029 99999 FALSE 6
540.741 7.62 0.050 1 99999 TRUE 7
540.743 9.144 0.068 99999 FALSE 8
540.746 10.668 0.083 99999 FALSE 9
540.753 12.192 0.136 99999 FALSE 10
540.758 13.716 0.157 99999 FALSE 11
540.758 15.24 0.136 1 99999 TRUE 12
the routine starts with the elevation set to absolute $A$2, 540.750. It
stays at that value until the condition is met, at which point the elev value
in the formula should change to $A$7, 540.741, and stay at that value until
it is met again, then change to $A$12, 540.758, etc. Does this make sense?
Thanks-cob