Between function
 

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.

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

=IF(AND(B11, 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




"Excel GuRu" wrote in message
...
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.

=if(and(a1=1, a1<=10),"good response","bad response")

"Excel GuRu" wrote:

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.