iDoceo 7 for macOS and iPadOS now available!

You will find all the details explained here
Welcome, Guest
Username: Password: Remember me

TOPIC: If formula

If formula 11 months 1 day ago #9377

  • Jgomez
  • Jgomez's Avatar
  • 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 (8)) 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 11 months 1 day ago #9378

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3349
  • Thank you received: 647
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 take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
The administrator has disabled public write access.
Time to create page: 0.111 seconds
21 AUG

iDoceo 7 for iPad and Mac now available!

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

Read more

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

Read more

Cookies policy

This website uses cookies to make it easier for you to use the forum. We do not track you for any kind of advertising or statistics. Cookies are only used to keep you logged in the forum in case you would like to post and to keep your language selection in case you use the automatic translation offered by Google. If you continue to use our offer and have activated this technology in your browser, you consent to the use of cookies.