Can someone help me create a point system on Excel?

Question

i.e., if a salesperson exceeds their monthly goals I would like to have a bonus ($) show up with a message like great job, etc.

Answer 1

OK - you need to put an "IF" statement in a cell where you want the 'great job' to appear: In this example, I said, If (I pointed to the referenced cell A1) more than 400, GREAT JOB...
=IF(A1>400,"GREAT JOB")

If you go to the formula wizards - there is also a line for "less than" an amount so you can put in DO BETTER....