Forum Discussion

Jara2400's avatar
Jara2400
Copper Contributor
Jan 23, 2024

IF function

I want to display 0 if the number is between 30 and 160, 1 if it is below 30 and 2 if it is above 160. How do I do this?
excel
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jan 23, 2024

Jara2400 

=IF(AND(A1>=30,A1<=160),0,IF(A1<30,1,IF(A1>160,2,"")))

 

This can be done with a nested IF formula.