Grade conversion (Excel If function)

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

Hello James,

Yes, you can do that with what we call a 'grade conversion'.
I'll prepare the article today and I'll post here the link.

In short, the steps are as follows:

If you have not done it already, you must create a text grade type with the steps explained here . Add your texts from A to U
The exact value of the percentages is not important, just make sure that the highest value has a 100%, the lowest 0%

Add now a new grade type but this time choose Grade conversion. Make sure the input max value is what you need (30?) and select as output the Text grade type you have created in the previous step. You will find a table at the bottom left corner that will let you enter the correlation between the score and the grade.
Once finished, assign this new grade type to your score column. Double tap header > Grade type > Your grade conversion.

Here a couple of screenshots of how the grade conversion looks

Here it is .
Let me know if something is not clear enough!

Regards

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?

Yes, you will find here the details and it will look like this

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?! :huh:
thanks

Hi Wendy, the issue may be due to:
- the columns leading to that final result not having the proper grade types.
- something wrong in the grade conversion's configuration

If you are working with the grade conversion, you should disable it for a moment. Double tap on the column's header > Grade type and change the grade type to something like 'From 0 to 100' for example.

If this yields the right result it is then only a matter of properly configuring the grade conversion, if you can send me a screenshot of your configuration (with the green graph) I'll see if I can spot the problem.

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.