# If formula

1 year 11 months ago #9377 by Jgomez
If formula was created by Jgomez
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?

Please Log in or Create an account to join the conversation.

1 year 11 months ago #9378 by bert
Replied by bert on topic If formula
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

Please Log in or Create an account to join the conversation.