I'm trying to replicate this formula on idoceo: =IF(G4>=52, "9", IF(G4>49, "8", IF(G4>47, "7", IF(G4>43, "6", IF(G4>40, "5", IF(G4>37, "4", IF(G4>29, "3", IF(G4>21, "2", IF(G4>14, "1", IF(G4>0, "U", "U" ))))))))))

I've basically got it but if a student meets to condition for a grade 5, then the column gives them a 5,4,3,2,1,U instead of just giving them only a 5.

At the minute my forumla looks like this in idoceo:

IF ( UNIT TOTAL > 52 , ICONRESULT (9)) OR IF ( UNIT TOTAL > 49 , ICONRESULT () OR IF ( UNIT TOTAL > 47 , ICONRESULT (7)) OR IF ( UNIT TOTAL > 43 , ICONRESULT (6)) OR IF ( UNIT TOTAL > 40 , ICONRESULT (5)) OR IF ( UNIT TOTAL > 37 , ICONRESULT (4)) OR IF ( UNIT TOTAL > 29 , ICONRESULT (3)) OR IF ( UNIT TOTAL > 21 , ICONRESULT (2)) OR IF ( UNIT TOTAL > 14 , ICONRESULT (1)) OR IF ( UNIT TOTAL > 0 , ICONRESULT ())

The icon for 0 is a red sad face... Any ideas where I'm going wrong?

Hello Jgomez,
For that kind of conversion it is easier to use a grade conversion (Menu > grade types > Conversion) where you specify the input range and the output result and all the intermediate variations you want.
Once configured assign that conversion to your column