One way:

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

In article ,
Ivano wrote:

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<A1100?

Thanks a lot for your help,