Doug Mutzig
Board Regular
- Joined
- Jan 1, 2019
- Messages
- 57
- Office Version
- 365
- Platform
- Windows
Hi all,
I am trying to work out how to automate the calculation of percentage increases based on an initial percentage range.
For example, if you were given a range of 3 to 9 % how do you take this range a split it into 4 groups with a high and low value in each? The first group's high would be the highest value from the range and the last (4th) group's low would be the lowest value from the range with the rest of the values being an even distribution.
I have tried a count of integers between the initial values, then adding 2 to account for the values in the range, and using the Sequence formula to generate a list of the values but I am stuck on if this is even the right way to go and how to proceed from there.
I am trying to work out how to automate the calculation of percentage increases based on an initial percentage range.
For example, if you were given a range of 3 to 9 % how do you take this range a split it into 4 groups with a high and low value in each? The first group's high would be the highest value from the range and the last (4th) group's low would be the lowest value from the range with the rest of the values being an even distribution.
I have tried a count of integers between the initial values, then adding 2 to account for the values in the range, and using the Sequence formula to generate a list of the values but I am stuck on if this is even the right way to go and how to proceed from there.