### iDoceo 6 is now available!

We are updating the web with all the new features of iDoceo 6.
This is a manual update, please tap on this link if you wish to update on the App Store

## If function 4 years 11 months ago #5564

 james.me.robinson OFFLINE Skilled member Posts: 32 Hi, I have set up my excel spreadsheet to show a grade based on the score using the if function. Is there a way of converting this formula so that it will work in my grade book in iDoceo? Here is the formula, where AC6 is the total mark column. IF(AC6>26,"*",IF(AC6>22,"A",IF(AC6>18,"B",IF(AC6>15,"C",IF(AC6>12,"D",IF(AC6>9,"E",IF(AC6>7,"F",IF(AC6>4,"G",IF(AC6<4,"U"))))))))) I can't seem to get the speech marks or text. Thanks The administrator has disabled public write access.

## If function 4 years 11 months ago #5566

 bert OFFLINE Admin Posts: 3054 Thank you received: 554 Here it is. Let me know if something is not clear enough! Regards Please take a moment to add or update your rating for iDoceo 6 teacher gradebook so that we can continue working on it. Thanks! Here is the link itunes.apple.com/us/app/idoceo-teachers-...&action=write-review The administrator has disabled public write access. The following user(s) said Thank You: james.me.robinson

## If function 4 years 11 months ago #5567

 james.me.robinson OFFLINE Skilled member Posts: 32 This is brilliant. Thank you. Really helpful and easy to follow instructions. This brings me onto one more feature I use in Excel. I usually get excel to auto format the grade compared to the target grade. E.g. When a student has met their target it is yellow. When above target green. When below target red. Is it possible to do conditional formatting like this? The administrator has disabled public write access.

## If function 4 years 11 months ago #5568

 bert OFFLINE Admin Posts: 3054 Thank you received: 554 Yes, you will find here the details and it will look like this Please take a moment to add or update your rating for iDoceo 6 teacher gradebook so that we can continue working on it. Thanks! Here is the link itunes.apple.com/us/app/idoceo-teachers-...&action=write-review Last Edit: 4 years 11 months ago by bert. The administrator has disabled public write access. The following user(s) said Thank You: james.me.robinson

## If function 4 years 10 months ago #5609

 Wendy OFFLINE Junior Member Posts: 5 this is a fantastic resource! have been exporting my gradebook to excel in order to use an if function for all our tracking needs, yet now I can do it directly in the gradebook, thanks. just one question, if I may: having set up my text grade type as standard AS grades with % decrements of 10, as far as 40. then 0 for U however, when using it, the column gives any value less than 40 as E not U. What have I done wrong?! thanks The administrator has disabled public write access.

## If function 4 years 8 months ago #5841

 Richard01902 OFFLINE New member Posts: 1 You want to put the max mark allowed for each grade in the grade conversion. This confused me at first! See the attached picture for my setup for A Level UMS that works. Attachments: image.jpg (36KB) The administrator has disabled public write access.
Time to create page: 0.129 seconds
9 DEC

iDoceo 6 is 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