| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple page if statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| COUNTIF Statement with Multiple Conditions in Different Ranges | Excel Worksheet Functions | |||
| Parameter Query-enter just once for use in multiple places | Excel Discussion (Misc queries) | |||
| IF Statement that's conditional on multiple IF Stmts in other cell | Excel Worksheet Functions | |||
Linear Mode
