Multiple parameter IF statement
 

Can anyone please help me with this:

The greater of D49 and I49 represents "Chargeable".
When Chargeable is:
1. Greater than D9 but less than E9, the value should be chargeable X D10
2. Greater than E9 but less than F9, the value should be chargeable X E10
3. Greater than F9 but less than G9, the value sholuld be chargeable X F10
4. Greater than G9, the value should be chargeable X G10

When the Chargeable X D10 or E10 or F10 or G10 is less than C10, the value
should be C10

Multiple parameter IF statement
 

I think this meets your requirements

=MAX(MAX(D49:E49)*LOOKUP(MAX(D49:E49),D9:G9,D10:G1 0),C10)


"Teri" wrote:

Can anyone please help me with this:

The greater of D49 and I49 represents "Chargeable".
When Chargeable is:
1. Greater than D9 but less than E9, the value should be chargeable X D10
2. Greater than E9 but less than F9, the value should be chargeable X E10
3. Greater than F9 but less than G9, the value sholuld be chargeable X F10
4. Greater than G9, the value should be chargeable X G10

When the Chargeable X D10 or E10 or F10 or G10 is less than C10, the value
should be C10

Multiple parameter IF statement
 

Oops - should have been

=MAX(MAX(D49,I49)*LOOKUP(MAX(D49,I49),D9:G9,D10:G1 0),C10)

"Teri" wrote:

Can anyone please help me with this:

The greater of D49 and I49 represents "Chargeable".
When Chargeable is:
1. Greater than D9 but less than E9, the value should be chargeable X D10
2. Greater than E9 but less than F9, the value should be chargeable X E10
3. Greater than F9 but less than G9, the value sholuld be chargeable X F10
4. Greater than G9, the value should be chargeable X G10

When the Chargeable X D10 or E10 or F10 or G10 is less than C10, the value
should be C10

Multiple parameter IF statement
 

Thank you!! Am going to run this by my boss to see if the answer is the one
he's looking for :)

"Duke Carey" wrote:

Oops - should have been

=MAX(MAX(D49,I49)*LOOKUP(MAX(D49,I49),D9:G9,D10:G1 0),C10)

"Teri" wrote:

Can anyone please help me with this:

The greater of D49 and I49 represents "Chargeable".
When Chargeable is:
1. Greater than D9 but less than E9, the value should be chargeable X D10
2. Greater than E9 but less than F9, the value should be chargeable X E10
3. Greater than F9 but less than G9, the value sholuld be chargeable X F10
4. Greater than G9, the value should be chargeable X G10

When the Chargeable X D10 or E10 or F10 or G10 is less than C10, the value
should be C10