One way:

=IF(A1<X,30,IF(A1<=Y, 33, 35))

In article ,
"Stumped by If Thens...." <Stumped by If
wrote:

Does anyone know the formula for "If between x & y, then z"? Someone's hourly
wage will be dependent upon three different ranges I will bill their time out
to clients.

If under X, then the hourly rate is $30
If between X and Y, then the hourly rate is $33
If over Y, then the hourly rate is $35