### iDoceo 8 for iPhone,iPad and Mac now available!

You will find all the details explained here

## If formula 1 year 9 months ago #9377

 Jgomez OFFLINE New member Posts: 1 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? The administrator has disabled public write access.

## If formula 1 year 9 months ago #9378

Time to create page: 0.142 seconds
21 AUG

iDoceo 7 for iPad and Mac now available!

A huge update with tons of new features and a new interface

6 JUN

Create Multiple-choice tests with iDoceo Connect!

In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template