=<or=> formula

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

One way:

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

In article <[email protected]>,
Dan <[email protected]> wrote:

> 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