Programming & Development
Math / Algorithms / Analytics
I need the following formula written for excel.
I want column b to = 1 when column A is < .52501 and column B will now stay at 1 until one of the following happens:
if A > .70, then column B should now = 0 until column A < .5201 again. or
Column A increases above .60 and then falls back down be ... Show more