IF statement (non nested) that compares cell value against range

[Guest]

Is it possible to write a non-nested IF statement that looks something like

IF(A2>=10 AND A2<100,"10-100","") or IF(a2 is between 10 and 100,"10-100","")

 

[Guest]

=if(and(A2>=10, A2<100),"10-100","")

 

[Tiah]

yes

 

[Guest]

Thank you.

=if(and(A2>=10, A2<100),"10-100","")

 

[swatsp0p]

You are close in your attempt. Try this:

=IF(AND(A2>=10,A2<=100),"10-100","")

Good Luck

Bruc