Moodle in English: Can you use IF function/statement in Moodle Grade calculations?

Gradebook

Can you use IF function/statement in Moodle Grade calculations?

This discussion has been locked because a year has elapsed since the last post. Please start a new discussion topic.

Can you use IF function/statement in Moodle Grade calculations?

by Pralad Dessai - Wednesday, April 6, 2016, 8:10 PM

Moodle is showing error if I put IF statement in the grade calculation formula box. I want Moodle to use IF function like how it works in Excelsheet.

The following is my formula:

= IF(D7="D",1,IF(D7="U",2,0))

Re: Can you use IF function/statement in Moodle Grade calculations?

by Mark McKay - Wednesday, April 6, 2016, 10:02 PM

Pralad,

Moodle doesn't allow IF statements in calculations. You can use a combination of max and min statements to accomplish this, it just takes a little more work with the logic.

Mark

Re: Can you use IF function/statement in Moodle Grade calculations?

by Pralad Dessai - Thursday, April 7, 2016, 12:06 PM

Hi Mark,

Can you please show me one example of how to use max and min statements in the following formula?

My formula is:

IF(B9>10,"Good",IF(B9<4,1,0))