### iDoceo 7 for macOS and iPadOS now available!

You will find all the details explained here

## If function 6 years 6 months ago #5564

 james.me.robinson OFFLINE Skilled member Posts: 33 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 6 years 6 months ago #5566

 bert OFFLINE Admin Posts: 3371 Thank you received: 653 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 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. The following user(s) said Thank You: james.me.robinson

## If function 6 years 6 months ago #5567

 james.me.robinson OFFLINE Skilled member Posts: 33 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 6 years 6 months ago #5568

 bert OFFLINE Admin Posts: 3371 Thank you received: 653 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 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 Last Edit: 6 years 6 months ago by bert. The administrator has disabled public write access. The following user(s) said Thank You: james.me.robinson

## If function 6 years 5 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 6 years 2 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.150 seconds

#### Recently updated articles

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