I am trying to create a formula to calculate potential bonus payments depending on what percentage is achieved.
I need to formula to do something like this If the score is between 75%-84.99% then no bonus but if the score is 85%-94.99% then 2.5% of Salary but if the score is 95%-100% then 10% of Salary.
I am struggling to get the answer.
Can anyone help?
Bookmarks