IF and Betwwen - how to ?

[H. Nissen]

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

 

[Mike H]

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]

Hi Mike

It was exactly what I was seeking, I thank so many times

Kinds Regards
H. Nissen


It is something like that, but this kode returns only "0"

"Mike H" skrev: