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" ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variance Analysis and Excel 1
Excel Formula and Variance Analysis 0
Scrabble Value calculation for Welsh words 0
Excel Need Countifs Formula Help 0
Formula help 0
Multiple value if function using dates 2
Average IF Function 3
Greater than 5 days formula 11

Back
Top