Multiple If (Lookup?) Statement
Hi Teri
I would use a helper cell to hold the chargeable value say J49 with a
formula of
=MAX(D49,I49)
Then
=IF(J49G9,J49*G10,IF(J49F9,J49*F10,IF(J49E9,J49 *E10,IF(J49D9,MAX(C10,J49*D10),""))))
If you want the result all in one cell, then just substitute
MAX(D29,I49) for every occurrence of J49 in formula above.
--
Regards
Roger Govier
"Teri" wrote in message
...
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
|