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