software

Hi,
I would like to test a cell and run a formula if the cell is inbetween two
values. For example.
IF(A1 lt;is inbetween values 1 and 100gt;,quot;YESquot;, quot;NOquot;)
I can't figure out how to tell Excel the inbetween part? do I use A1=1:100
or 1lt;A1gt;100?

Thanks a lot for your help,One way:

=IF(AND(A1gt;1,A1lt;100),quot;YESquot;,quot;NOquot;)

In article gt;,
Ivano gt; wrote:

gt; Hi,
gt; I would like to test a cell and run a formula if the cell is inbetween two
gt; values. For example.
gt; IF(A1 lt;is inbetween values 1 and 100gt;,quot;YESquot;, quot;NOquot;)
gt; I can't figure out how to tell Excel the inbetween part? do I use A1=1:100
gt; or 1lt;A1gt;100?
gt;
gt; Thanks a lot for your help,

try
=if(and(Agt;=1,Alt;=100),quot;yesquot;,quot;noquot;)

quot;Ivanoquot; wrote:

gt; Hi,
gt; I would like to test a cell and run a formula if the cell is inbetween two
gt; values. For example.
gt; IF(A1 lt;is inbetween values 1 and 100gt;,quot;YESquot;, quot;NOquot;)
gt; I can't figure out how to tell Excel the inbetween part? do I use A1=1:100
gt; or 1lt;A1gt;100?
gt;
gt; Thanks a lot for your help,
gt;

You want the And function, as in:

=if(and(a1gt;1,a1lt;100),true,false)

--
Regards,
Fredquot;Ivanoquot; gt; wrote in message
...
gt; Hi,
gt; I would like to test a cell and run a formula if the cell is inbetween two
gt; values. For example.
gt; IF(A1 lt;is inbetween values 1 and 100gt;,quot;YESquot;, quot;NOquot;)
gt; I can't figure out how to tell Excel the inbetween part? do I use A1=1:100
gt; or 1lt;A1gt;100?
gt;
gt; Thanks a lot for your help,
gt;
You could also set the formula up to allow you to put the Minimum (C1) and
Maximum (C2) limits in another cell and not have to go in and change the
formula itself if this condition arizes regularly.

=IF(AND(A1gt;C1,A1lt;C2),quot;YESquot;,quot;NOquot;)Vaya con Dios,
Chuck, CABGx3

quot;Ivanoquot; wrote:

gt; Hi,
gt; I would like to test a cell and run a formula if the cell is inbetween two
gt; values. For example.
gt; IF(A1 lt;is inbetween values 1 and 100gt;,quot;YESquot;, quot;NOquot;)
gt; I can't figure out how to tell Excel the inbetween part? do I use A1=1:100
gt; or 1lt;A1gt;100?
gt;
gt; Thanks a lot for your help,
gt;

thanks AND thanks AND thanks AND thanks .... get it quot;ANDquot; : ))

quot;Ivanoquot; wrote:

gt; Hi,
gt; I would like to test a cell and run a formula if the cell is inbetween two
gt; values. For example.
gt; IF(A1 lt;is inbetween values 1 and 100gt;,quot;YESquot;, quot;NOquot;)
gt; I can't figure out how to tell Excel the inbetween part? do I use A1=1:100
gt; or 1lt;A1gt;100?
gt;
gt; Thanks a lot for your help,
gt;