I was going to quickly mock up some logic in excel for another project I'm working on and ran into a problem I cant solve without creating dependency loops.
I'm looking for a less than comparison with a bias:
and would remain true until:
Here is as close as I could get, but of course its a direct dependency loop. (A1 being the cell with the function)
I could do the same thing in VB, but it seems like it should be simple function. 
(Sorry, double quotes added around comparison operators because it wouldn't display properly without them)
I'm looking for a less than comparison with a bias:
Code:
=IF(X1"<"Y1,1,0)
Code:
=IF(X1">"Y1+B1,1,0)
Here is as close as I could get, but of course its a direct dependency loop. (A1 being the cell with the function)
Code:
=IF(A1=0,IF(X1"<"Y1,1,0),IF(X1">"Y1+B1,1,0))

(Sorry, double quotes added around comparison operators because it wouldn't display properly without them)