Hi there,
Hoping someone can help me.
I need to split usage of units in different columns (without using VBA):
For example-
Total Usage: 29 (B3)
Column C: The first 1 to 12 unit are free
Column D: Units 13-25 are charge 1
Column E: Units 26+ are charge 2
I want to the split the usage automatically into the different columns with a formula.
Is this possible?
Any help would be appreciated. Please note that I am not allowed to use VBA on the system.
<tbody>
</tbody>
Thank you.
Hoping someone can help me.
I need to split usage of units in different columns (without using VBA):
For example-
Total Usage: 29 (B3)
Column C: The first 1 to 12 unit are free
Column D: Units 13-25 are charge 1
Column E: Units 26+ are charge 2
I want to the split the usage automatically into the different columns with a formula.
Is this possible?
Any help would be appreciated. Please note that I am not allowed to use VBA on the system.
A | B | C | D | E | |
1 | <strike></strike> | <strike></strike>Usage | Free | Charge 1 | Charge 2 |
2 | 1-12 | 13-25 | 26+ | ||
3 | 481 | 29 | 12 | 13 | 4 |
4 | 457 | 7 | |||
5 | 132 | 13 | 12 | 1 |
<tbody>
</tbody>
Thank you.