| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple If (Lookup?) Statement
Can anyone help me write this formula?
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 should be chargeable X E10 4. Greater than G9, the value should be chargeable XG10 When the Chargeable X D10 is less than C10, the value should be C10 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup function for multiple worksheets...and then 'some' | Excel Worksheet Functions | |||
| Lookup multiple values return one value corresponding value Excel | Excel Worksheet Functions | |||
| multi sheet lookup with multiple results | Excel Discussion (Misc queries) | |||
| Multiple lookup value's | Excel Worksheet Functions | |||
| Multiple Criteria Lookup Question | Excel Discussion (Misc queries) | |||
Threaded Mode
