If statement for value between two numbers

[Khalil Handal]

Hi,

I have this If statement and I want to modify it for cell BY15 values only between 1 and 4 instead of less than 4.

=IF(AND(BY15<4,BV15=2),$BX$4,$BX$5)

in other words:
IF BY15=1,2,3 then result should be $BX$4.
IF BY15 = 0 then result should be $BX$5.

How can this be done ?

Khalil

[wk9128]

Meet BY15 (1~4) AND BV15=2 to be established $BX$4 , otherwise $BX$5

Try

=IF(AND(BY15>=1,BY15<=4,BV15=2),$BX$4,$BX$5)

[Khalil Handal]

Thank you very much.
Result accomplished.

Khalil