lundi 7 janvier 2019

How do I create an if-then formula in excel that produces a written text answer?

=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