General discussion
March 22, 2002 at 03:38 AM
lf king

Excel IF Formula

by lf king . Updated 24 years, 5 months ago

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

This discussion is locked

All Comments