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