ExcelBanter - IF and Betwwen

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF and Betwwen - how to ? (https://www.excelbanter.com/excel-worksheet-functions/193726-if-betwwen-how.html)

H. Nissen[_2_]

IF and Betwwen - how to ?

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

IF and Betwwen - how to ?

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

H. Nissen[_2_]

IF and Betwwen - how to ?

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

All times are GMT +1. The time now is 03:58 AM.