Trying to finish off a formula

[sflawson]

I'm trying to do a calculation where thing up to 1,000,000 are calculated at 5.5%, above 1,000,000 - 1,500,000 are calculated at 6.5% then anything above 1,500,000 are calculated at 7.5%.

I started the below formula and it works until I get above 1,500,000. The underlined formula is what I tried to add to finish the above idea but something is wrong. Any suggestions?

=IFS(P14<=1000000,0.055*P14,AND(P14>1000000,P14<=1500000),P14*0.065),AND(P14>=1500000,P14<=2000000),P14*.075)

 

[Fluff]

Duplicate to: Formula to increase percentage in smooth ramp

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.