Between function

[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_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




"Excel GuRu" <ExcelGuRu@discussions.microsoft.com> wrote in message
news:40A094A5-CBCD-417F-81EF-1883CEAA816F@microsoft.com...
> 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.

[Jonathan Cooper]

=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.