IF and Betwwen - how to ?

  • Thread starter Thread starter H. Nissen
  • Start date Start date
H

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
 
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
 
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:
 
Back
Top