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