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

"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

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:

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