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.

"Nick Hodge" wrote:

Ben

I think you want something like

=IF(AND(A1=A2,A1<A3),"YY",IF(A1=A2,"XX","ZZ"))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"ben simpson" wrote in message
...
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