Trouble writing an excel formula...

[Stumped by If Thens....]

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

 

[JE McGimpsey]

One way:

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

"Stumped by If Thens...." <Stumped by If

 

[Arvi Laanemets]

Hi

With value to process in cell A1:
=30+3*(A1>=X)+2*(A1>Y)
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
(e-mail address removed)> wrote in message
news:[email protected]...

 

[JE McGimpsey]

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