I am trying to put together a bonus calculator in excel. I cannot figure how to calculate this:
If 70 = 0%, 80 = 100% and 90 is 200%. I need for the numbers between 70 and 90 to be the appropriate %.
Example: 75 is 50% and 85 is 175%.
I have other problems using dollars.
If 70 = 0%, 80 = 100% and 90 is 200%. I need for the numbers between 70 and 90 to be the appropriate %.
Example: 75 is 50% and 85 is 175%.
I have other problems using dollars.