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