Falling within a range

B

ben simpson

What would be the best way to create a formula to say:

If a A1 is >= than A2, the result is XX, and if not ZZ ,and if at the
same time A1 is < A3, the result is YY, or the same ZZ.

I'm trying to check if a number falls within a range of numbers, it gives me
a result, and the result remains until it no longer falls within the same
range.

Does any of this make any sense? Thank you for looking in....Ben
 
B

ben simpson

Thank you very much Nick. Exactly what i was looking for. Sometimes one can
look at a problem for too long and not realize the logic.
 
Top