software

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

If a A1 is gt;= than A2, the result is XX, and if not ZZ ,and if at the
same time A1 is lt; 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

Ben

I think you want something like

=IF(AND(A1gt;=A2,A1lt;A3),quot;YYquot;,IF(A1gt;=A2,quot;XXquot;,quot;ZZquot;))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HISquot;ben simpsonquot; gt; wrote in message
...
gt; What would be the best way to create a formula to say:
gt;
gt; If a A1 is gt;= than A2, the result is XX, and if not ZZ ,and if at the
gt; same time A1 is lt; A3, the result is YY, or the same ZZ.
gt;
gt; I'm trying to check if a number falls within a range of numbers, it gives
gt; me
gt; a result, and the result remains until it no longer falls within the same
gt; range.
gt;
gt; Does any of this make any sense? Thank you for looking in....Ben
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.

quot;Nick Hodgequot; wrote:

gt; Ben
gt;
gt; I think you want something like
gt;
gt; =IF(AND(A1gt;=A2,A1lt;A3),quot;YYquot;,IF(A1gt;=A2,quot;XXquot;,quot;ZZquot;))
gt;
gt; --
gt; HTH
gt; Nick Hodge
gt; Microsoft MVP - Excel
gt; Southampton, England
gt; www.nickhodge.co.uk
gt; HIS
gt;
gt;
gt; quot;ben simpsonquot; gt; wrote in message
gt; ...
gt; gt; What would be the best way to create a formula to say:
gt; gt;
gt; gt; If a A1 is gt;= than A2, the result is XX, and if not ZZ ,and if at the
gt; gt; same time A1 is lt; A3, the result is YY, or the same ZZ.
gt; gt;
gt; gt; I'm trying to check if a number falls within a range of numbers, it gives
gt; gt; me
gt; gt; a result, and the result remains until it no longer falls within the same
gt; gt; range.
gt; gt;
gt; gt; Does any of this make any sense? Thank you for looking in....Ben
gt;
gt;
gt;