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

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Dajana wrote in message
...
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