Between function

E

Excel GuRu

Is there a function in Excel that will determine whether a cell value is
between x and y? I can't find one.

I'd like to write an "IF" formula that returns a certain result if the
value is between 1 and 100 and a different result if it isn't.

Please let me know the proper syntax of the "Between" function if you can.
 
X

X_HOBBES

Well, sort of... it's not a dedicated 'between' function, but this is how:

=IF(AND(B1>1, B1<100), TrueValueHere, FalseValueHere)

where B1 is the cell you're looking at. You probably want it to be
inclusive of the 1 and 100, so it might need to be like this:

=IF(AND(B1>=1, B1<=100), TrueValueHere, FalseValueHere)

X_HOBBES
 
Top