IF with Equal to or Greater than
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
|