Formula Queries - Finding Min/Max of Value Using Foreign Key in Other Table

I'm trying to use this method and it seems like there is a problem with the logic.

Not counting the state part of the equation, if I have records:
RID    Value
1          10
2         10
3         200
4         100

Record 1 only has 1 record that is GTE 10 and has a RID LTE 1 (itself)
Record 2 has 2 records that are GTE 10 and has a RID LTE 2 (itself and #1)
Record 3 is back down to 1 record that is GTE 200 and has a RID LTE 3 (itself)
Record 4 has 2 records that are GTE 100 and has a RID LTE 4 (itself and #3) 

I can't figure out how to work the GTE and LTE (as well as LT, GT, XEX, etc.) to get a unique value for RID 3, whether it is a 0 or 1.

Any suggestions? Something I might be missing?