=<or=> formula

[Dan]

I want to have a cell = a value based on anothers cells input

ex. =IF(P3>=Q2and<=Q3,M3,R3)

I can get it to work with
=IF(P3>=Q2,M3,R3)
however I need the secound part of the range

Thanks Dan

 

[JE McGimpsey]

One way:

=IF(AND(P3>=Q2,P3<=Q3),M3,R3)