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

  • Thread starter Thread starter B Fresh
  • Start date Start date
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....
 
Try

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

where A1 is the cell receiving the input.

Hope this helps,

Hutch
 
Back
Top