In between

  • Thread starter Thread starter J Shrimps, Jr.
  • Start date Start date
J

J Shrimps, Jr.

Is there no "between" function like Access in Excel?
Need to determine if a value is between two sets of
values.
Formula below is what I'm using
from Walkenbach's book, displaying
the number 1 if the value in cell M42 does
not fall within values in cells M46, M50
M52 and M53.
=IF(AND(M42>M46,M42>M50),1,
IF(AND(M42<M46,M42<M50),1,
IF(AND(M42>M52,M42>M53),1,
IF(AND(M42<M52,M42<M53),1))))
Seems a bit long just to check if a value
falls between two other sets of values...
 
Somewhat shorter:

=IF((M42<M46)+(M42>M50)+(M42<M52)+(M42>M53)>1,1)

HTH
Jason
Atlanta, GA
 
You must log in or register to reply here.

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

Macro to check if current cell value is 1 and previous cell was 0 6
IF AND Nested Functions - Formula Not Working 0
Home Network 1
SUMPRODUCT 2
Clear checkboxes 1
Hours between to two times 3
Need help in VBA 5
Help with Code 3

Back
Top