=IF(J35>130,["Way_Above_Average"]),IF(AND(J35>=119,J35<=130),["Above_Average"]),IF(AND(J35>=109,J35<=118),["High_Average"]),IF(AND(J35>=89,J35<=108),["Average"]),IF(AND(J35>=80,J35<=90),["Low_Average"]),IF(AND(J35>=68,J35<=79),["Below_Average"]),IF(AND(J35>=61,J35<=67),["Way_Below_Average"]))
I am trying to create a "report template" that takes the raw testing data of students from a Normed test...and creates a description of the score as compared to peers in the same grade.
=IF(J35>130,["Way_Above_Average"]),IF(AND(J35>=119,J35<=130),["Above_Average"]),IF(AND(J35>=109,J35<=118),["High_Average"]),IF(AND(J35>=89,J35<=108),["Average"]),IF(AND(J35>=80,J35<=90),["Low_Average"]),IF(AND(J35>=68,J35<=79),["Below_Average"]),IF(AND(J35>=61,J35<=67),["Way_Below_Average"]))
I keep getting error messages about syntax and name...want this to create a text descriptor from the raw standard score.
Aucun commentaire:
Enregistrer un commentaire