Hi Duke! Yes, when I ran the formula, it displayed a #N/A in the cell. This
one works perfectly!

Thank you EVERYBODY for your help :)

"Duke Carey" wrote:

OK - you've changed your requirements from the other day.

=IF(MAX(D49,I49)*D10<C10,C10,MAX(D49,I49)*LOOKUP(M AX(D49,I49),D9:G9,D10:G10))



"Teri" wrote:

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