$=$IF$($O$2=$"Very Dissatisfied"$),"1",$IF$($OR$($O$2=$"Somewhat Dissatisfied"$),"2",$IF$($OR$($O$2=$"Neutral"$),"3",$IF$($OR$($O$2=$Somewhat Satisfied$),4,$IF$($OR$($O$2=$Very Satisfied$),$AC$4$

This is the formula I came up with above. What am I doing wrong?

The question from the teacher is below.

Transform the satisfaction ratings from Very Dissatisfied, Somewhat Dissatisfied, Neutral, Somewhat Satisfied, and Very Satisfied to the numbers $1-5($Very Dis $=1,$ Very Sat $=5).$ Use the Satisfaction Column for this.