I’m tracking employee performance in excel and need help with a formula. The formula inserted is:
=IF(H9=30000,”15″,IF(H9=60000,”30″,IF(H9=90000,”45″,IF(H9=120000,”60″,IF(H9=150000,”75″,IF(H9=180000,”90″,”No Yards Gained”))))))
H9 contains a formula that sums H4:H8. If that total reaches the breaks above the team gets the points.
The numbers refer to dollar amounts of new accounts- each employee that opens a new account helps the team to make yards.
The formula works fine if I enter 10,000, 20,000 30,000 etc. But if I enter numbers like 2,224, 9,874 (which is real world)it doesn’t put in points.
Please Help