newbie looking for help

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

 
Data Range
A
B
C
D
E
F
1
Amount​
Multiplier​
Amount​
Multiplier​
2
50​
2​
0​
1​
3
41​
2​
4
81​
2.5​
5
121​
3​

Formulas
Data Range
A
B
C
D
E
F
1
Amount​
Multiplier​
Amount​
Multiplier​
2
50​
=VLOOKUP(A2,$E$2:$F$5,2,TRUE)​
0​
1​
3
41​
2​
4
81​
2.5​
5
121​
3​
 
Back
Top