theloudbloke
New Member
- Joined
- Nov 27, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
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
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