How to write IF function in Excel 2000 when there are two conditi.

[Dajana]

I need to write the IF function for two conditions: if a cell value is >2 but
at the same time <4 (between 2 and 4) if true is equal to 4 otherwise if
false is equal to 1. That is I want the cell value if between 2 and 4 to be
equal to 4 and for all other values that are less then 2 and greater than 4
to be equal to 1.

Thank you

 

[Max]

Assume the value monitored is in A1
Try in say, B1: =IF(AND(A1>2,A1<4),4,1)