Formula to increase percentage in smooth ramp

[sflawson]

Hi All,
I had a wonderful formula that I lost and I'm trying to rebuild.

What I would like to do is, gradually increase a percentage applied to a total between multiple values.

For example, if the total was 1,000,000 I would like to calculate 5.5%, but as the total increased to 1,500,000, I would like the percentage to increase to 6.5%, then if the total increased to 2,000,000 or above I would like the percentage to increase to 7.5% in a smooth ramp. For now that's as far as I need to go but I'm sure one day I'll need to expand on this and continue adding other "breakpoints" for the increases.

I used the below formula that I found on a previous post but cannot get my 3rd piece to work.
=IFS(P14<=1000000,0.055*P14,AND(P14>1000000,P14<=1500000),P14*0.065)

This is where I'm failing (in red)...
=IFS(P14<=1000000,0.055*P14,AND(P14>1000000,P14<=1500000),P14*0.065),AND(P14>=1500000,P14<=2000000),P14*.075)

Thanks
Steph

 

[Dave Patton]

Thanks for the feedback.
N.B. B2 could be =SUMPRODUCT(--(B1>A8:A10),B1-A8:A10,C8:C10)