Im trying to update a formula for our employee bonus system, but Im afraid
Ive got in a bit of a muddle.
We currently have
=IF(x<60,0,(2.5*(x-60)))

Where x is the number of points they achieve in a week. They get paid £2.50
for every point over 60points.
I want to change it so that up to 150 points they get paid £2.10 for every
point over 60, but it cuts off at 150 points.
Then shown on a separate line (so they can see the distinction) I want to
show £2.15 for every point between 150 & 175 points.
Then again on a separate line £2.20 for any points over 200
I really have no idea how to go about this €“ I think this forum helped me
set up the original formula 3 years ago!
Can anyone help?
Thanks