Note: You are currently viewing documentation for Moodle 3.7. Up-to-date documentation for the latest stable version of Moodle may be available here: Grade calculations.

Difference between revisions of "Talk:Grade calculations"

From MoodleDocs
(More details that should be included in the page.)
Line 7: Line 7:
  
 
[[User:Luca Bösch|Luca Bösch]] ([[User talk:Luca Bösch|talk]]) 12:24, 12 April 2019 (UTC)
 
[[User:Luca Bösch|Luca Bösch]] ([[User talk:Luca Bösch|talk]]) 12:24, 12 April 2019 (UTC)
 +
 +
I have discovered through trial and error that if the condition in a grade calculation includes an equals sign / comparison operator, it must be double.
 +
 +
For example, =IF([[A1]]==10, 10, 0) is a valid calculation, but =IF([[A1]]=10, 10, 0) is not.
 +
 +
Furthermore, functions can be written in uppercase or lowercase letters.
 +
 +
--[[User:Richard Samson|Richard Samson]] ([[User talk:Richard Samson|talk]]) 11:27, 17 October 2019 (UTC)

Revision as of 11:28, 17 October 2019

I tried to improve this page providing explanations of the examples, generalize the content, correct some minor errors.

As of october 2018 there is no more 'Categories and items' to click in Grades. Also, the image https://docs.moodle.org/37/en/images_en/6/68/neweditcalculation.png is outdated. Probably https://docs.moodle.org/37/en/Grade_calculations#Setting_a_grade_calculation should be rewritten.

I wanted to add the exactly same comment. Click the 'Categories and items' is not even a proper phrase IMHO.

Luca Bösch (talk) 12:24, 12 April 2019 (UTC)

I have discovered through trial and error that if the condition in a grade calculation includes an equals sign / comparison operator, it must be double.

For example, =IF(A1==10, 10, 0) is a valid calculation, but =IF(A1=10, 10, 0) is not.

Furthermore, functions can be written in uppercase or lowercase letters.

--Richard Samson (talk) 11:27, 17 October 2019 (UTC)