If Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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...
Click to expand...


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


--ron
 
Thanks ron
How can it display "below the range", "Within the range" , Above the range" ?
 
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" ?
 
Back
Top