Hi,

Do you mean this?

=IF(AND(A1=112,A1<150),0,A1)

You may have to change the , to ; if the syntax of your region requires it.

Mike

"H. Nissen" wrote:

I need to make a "IF" funtion, which is dependent on the value of a
particular cell.

"If the value A1 is between 112 and 150; 0; A1"

How do I make "between" in an "IF" phrase?

I will be very happy for a good tips:)

Kinds Regards

H. Nissen