I am using SharePoint 2007 and trying to automate a couple of columns using calculated value. I have three columns that you enter a number and in the 4th column it totals the average (this works fine). However, I am trying to add a 5th column that a assigns a ranking based on the average score and can't get it to work. If I put the formula in Excel it works perfectly, but not in SharePoint. What am I doing wrong?
=IF( AVERAGE([Call 1 Score %],[Call 2 Score %],[Call 3 Score %])<85 ,"DO" ,IF( AVERAGE([Call 1 Score %],[Call 2 Score %],[Call 3 Score %])<93 ,"SP" ,"RM" ) )
=IF( Combined Score Avg<85 ,"DO" ,IF( Combui<93 ,"SP" ,IF( B2>92.9 ,"RM" ) ) )
The bolded example column is where the trouble is.
Call1 Call2 Call3 Avg Rating 85 92 78 85 **SP**