Multiple If statements and text in formula

[oxicottin]

Hello, I want my cell that holds the formula to give a result of text. If AC24 value is equal to the value of AC2 then I want the text to show "Goal Achieved!" and if not !","Not there Yet!" and then I want to add a second If statement to that If AC24 value is greater than AC2 then I want the text to show "Over Achiever!" and if not !","Not there Yet!". How do I put these two If statements together?


=IF(AC24=AC2,"Goal Achieved!","Not there Yet!")

IF(AC24>AC2,"Over Achiever!","Not there Yet!")

 

[philwojo]

Try:

[COLOR=#333333]=IF(AC24=AC2,"Goal Achieved!",if(ac24>ac2,"Over Achiever!","Not there Yet!"))[/COLOR]

 

[oxicottin]

Thank you...