I have an issue in Excel 2007 that I do not have the formula knowledge to write.
We own a hairdressers and wish to display targets to our employees. We have a spreadsheet that is working fine for each employee.
As an example say “Tom” has earned £897.03 (I15) this month and we have paid him £353.92 (I25)
We have used the below calculation to work out a simple % =I15/I25-1 = 153%
Here is my issue.
We want to be able to give a commission of 20% if he makes more than 2.7 times his wages.
Can this be done?