Formula to increase percentage in smooth ramp

[theloudbloke]

Hi All
This is more a math question than Excel.

What I would like to do is, gradually increase a percentage applied to a total between 2 values. For example, if the total was 500 I would like to calculate 0.5%, but as the total increased to 1000, I would like the percentage to increase to 1%, in a smooth ramp.
I'm sure it's not difficult, just beyond my math capabilities.
Thanks
T

 

[maabadi]

I think you want if your data lower than or equal 500 , calculate 0.5% And if more than 500 and lower than 1000 Calculate 1%.
then formula is (if your first data is in A2):

=IFS(A2<=500,0.05*A2,AND(A2>500, A2<=1000),0.1*A2)

and If you want to Percentage increase by value from 500 to 1000 , from 0.5% to 1% Use this:

=IFS(A2<=500,0.05*A2,AND(A2>500, A2<=1000),A2^2 * 0.0001)

 

[theloudbloke]

Thank you very much.

I'll get it into a spreadsheet and have a play around with it.

Cheers.