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)
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)