ScotIain76
New Member
- Joined
- Oct 26, 2021
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Good morning
I would appreciate any advice on how I can create a formula to split a value up into 3 separate columns.
I want to calculate the amounts due as I need to pay the first 10 metres @£10, the next 90 metres @ £10 and the remaining (if any) @ £1 with the maximum anyone can receive being £3000
Some values are <10m, <100m etc.
Hopefully my attached example makes sense
I would appreciate any advice on how I can create a formula to split a value up into 3 separate columns.
I want to calculate the amounts due as I need to pay the first 10 metres @£10, the next 90 metres @ £10 and the remaining (if any) @ £1 with the maximum anyone can receive being £3000
Some values are <10m, <100m etc.
Hopefully my attached example makes sense