Using IF function for inbetween cell values

[Ivano]

Hi,
I would like to test a cell and run a formula if the cell is inbetween two
values. For example.
IF(A1 <is inbetween values 1 and 100>,"YES", "NO")
I can't figure out how to tell Excel the inbetween part? do I use A1=1:100
or 1<A1>100?

Thanks a lot for your help,

 

[JE McGimpsey]

One way:

=IF(AND(A1>1,A1<100),"YES","NO")

 

[bj]

try
=if(and(A>=1,A<=100),"yes","no")

 

[Fred Smith]

You want the And function, as in:

=if(and(a1>1,a1<100),true,false)

 

[CLR]

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(A1>C1,A1<C2),"YES","NO")


Vaya con Dios,
Chuck, CABGx3

 

[Ivano]

thanks AND thanks AND thanks AND thanks .... get it "AND" : ))