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?