Use an IF Function to work out if exercises equipment is rated good or bad.
Equipment Units Sold Rating Price Tax Final Price Total Sum Good/Bad Rating
Treadmill 23 4 £140.00 £563.50 £703.50 3220.00
Exercise Bike 54 5 £235.00 £2,220.75 £2,455.75 12690.00
Rowing Machine 34 3 £232.00 £1,380.40 £1,612.40 7888.00
Step Machines 23 4 £145.00 £583.63 £728.63 3335.00
Bench 23 2 £250.00 £1,006.25 £1,256.25 5750.00
Dumbells 53 4 £230.00 £2,133.25 £2,363.25 12190.00
Cross Country 23 5 £120.00 £483.00 £603.00 2760.00
Bookmarks