stevea99
New member
- Joined
- May 3, 2019
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- mac version
Hi looking to make a formula for excel as follows
first 40 @ £1
40 to 80 @£2
80 to 120 @ £2.50
120 to 160 @ £3
how would i replica this so that I put in the number of up to 160 and it works out my bonus for work
Thanks
first 40 @ £1
40 to 80 @£2
80 to 120 @ £2.50
120 to 160 @ £3
how would i replica this so that I put in the number of up to 160 and it works out my bonus for work
Thanks