IF with Equal to or Greater than

  • Thread starter Thread starter sonicj
  • Start date Start date
S

sonicj

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
 
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
 
Just to be more clear -

It sees the >0.1, recognizes that it is true before it even gets to
the >0.3 IF statement and completes your equation based on that.
 
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,C3*0.01)))))
 
Glad to be of service!

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,C3*0.01)))))







- Show quoted text -
Click to expand...
 
Back
Top