If Function

[Steve D]

If I want to find a number I can write a formular =if(a1>5,a1,"Is less than 5") would display A1 if it were greater than 5, if not it would display Is less than 5... coo
How do I ask if A1 is greater than 5 but less than 10 display A1...

 

[Ron Rosenfeld]

If I want to find a number I can write a formular =if(a1>5,a1,"Is less than 5") would display A1 if it were greater than 5, if not it would display Is less than 5... cool
How do I ask if A1 is greater than 5 but less than 10 display A1...

=IF(AND(A1>5,A1<10),A1,"Not in Range")


--ron

 

[Steve]

Thanks ron
How can it display "below the range", "Within the range" , Above the range" ?

 

[Mark Graesser]

You could use nested IF statements

=IF(A1<5,"below the range",IF(A1>10,Above the range","Within the range")

This will return BTR if it is low, ATR if it is high, and WTR if it is neither

Good Luck
Mark Graesse
(e-mail address removed)

----- Steve wrote: ----

Thanks ron
How can it display "below the range", "Within the range" , Above the range" ?