How do I Make a "IF" formula where it reads between 2 sets of numb

B

B Fresh

Basically i need the formula to say "YES" if a number is inputed into a cell
that is less then or equal to 7299 and "NO" if the inputed number is in
between 7299 & 13085. But...(where i'm having the most trouble) say "YES" if
the inputed numbers is greater than or equal to13085....
 
T

Tom Hutchins

Try

=IF(OR(A1<=7299,A1>=13085),"YES","NO")

where A1 is the cell receiving the input.

Hope this helps,

Hutch
 

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

How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
How do I display 0 if it is the end result for a formula 4
"If" Formula Error 3
Is there a BETWEEN function? 7
How do I reference a formula to a dropdown list 1
If Formula 15
Conditional Formatting of a Percent Number 2
How do I write an excel formula with a text answer ("yes" or "no") 1

Top