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

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

Hi

With value to process in cell A1:
=30+3*(A1=X)+2*(A1Y)
Unlike using nested IF, you aren't limited with 7 nesting levels. And
probably it will work faster too.


Arvi Laanemets


"Stumped by If Thens...." <Stumped by If
wrote in message
...
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

Long before 7 nesting levels became an issue, I'd think one would want
to use a lookup. The simpler maintenance in most cases would trump
faster calculation...

In article ,
"Arvi Laanemets" wrote:

With value to process in cell A1:
=30+3*(A1=X)+2*(A1Y)
Unlike using nested IF, you aren't limited with 7 nesting levels. And
probably it will work faster too.