Glad to be of service!

On May 1, 3:35*pm, sonicj wrote:
Perfect! *Thank you.
=(B3+C3)+IF(D3=0.5,C3*0.03,IF(D3=0.4,C3*0.025,IF (D3=0.3,C3*0.02,IF(D3=0*.2,C3*0.015,IF(D3=0.1,C 3*0.01)))))



" wrote:
You have to invert your values - start with highest to lowest, rather
than the order you have it.

IF D3 0.3, it is also true that it is 0.1

On May 1, 1:58 pm, sonicj wrote:
Okay, what am I doing wrong? *B3 and C3 are being added properly, but when it
gets to the IF function it will only add C3*.01 to that total regardless of
how high I set the value in D3. * *

=(B3+C3)+IF(D3=0.1,C3*0.01,IF(D3=0.2,C3*0.015,IF (D3=0.3,C3*0.02,IF(D3=0**.4,C3*0.025,IF(D3=0.5, C3*0.03)))))

Thank you- Hide quoted text -

- Show quoted text -