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