Excel If Function

[dianedeetran]

What's the function if I wanted to say if cell 1 is greater than cell 2 AND if cell 1 is less than cell 3, In Range, Out of range?

Thank yoU!

[NBVC]

=IF(AND(A1>A2,A1<A3),"In Range","Out of range")

[dianedeetran]

It's not working: Cell 1= 16, cell 2=17.50 cell 3=32.50.

It's saying it is in range when 16 is less than 17.

what am i doing wrong?

[NBVC]

Replace A1, A2 and A3 with your actual cell reference (locations of Cell 1, Cell 2 and Cell 3, respectively).... It should say "Out of Range"

[dianedeetran]

This is what I have:

=IF(AND(N43<$I$43,N43<$J$43),"in range","out of range")

I43=17
J43-32

N43=16

It's saying 16 is in the range of 17 and 32 which isn't correct.

Thank you for helping.

[NBVC]

Per your original request... shouldn't it be?

=IF(AND(N43>$I$43,N43<$J$43),"in range","out of range")

[dianedeetran]

Sorry the first request was wrong.

N43 is referencing against two cells.

[NBVC]

I understand that but if you want to check if 16 is between 17 and 32

then

=IF(AND(N43>$I$43,N43<$J$43),"in range","out of range")

is the formula....

[dianedeetran]

Thank you! I must have mis keyed the arrow.