Multiple parameter IF statement

T

Teri

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
 
D

Duke Carey

I think this meets your requirements

=MAX(MAX(D49:E49)*LOOKUP(MAX(D49:E49),D9:G9,D10:G10),C10)
 
D

Duke Carey

Oops - should have been

=MAX(MAX(D49,I49)*LOOKUP(MAX(D49,I49),D9:G9,D10:G10),C10)
 
T

Teri

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top