Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |