IF condition to return 3 variants

hi,

I am new to excel but what I want to do is relatively simple and I hope you can help. I've been struggling with the syntax for a formula that will return the following:

IF AM9 > I9 return the word "Overachieving"
IF AM9 < I9 return the word "Underachieving"
IF AM9 = I9 return the word "On Target"

Thanks in advance.

Try this:

=IF(AM9 > I9, "Overachieving", IF(AM9 = I9,"On Target","Underachieving"))

Many thanks StepenR