Jump to content

ucznmsb

Members
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About ucznmsb

  • Rank
    Lepton
  1. Thank you Sensei, this is very helpful. Matt
  2. Apologies, if I have put this in the wrong section but I don't know enough about Maths to know what kind of question it is! I need to represent an IF statement formula in an alternative way as the software I am using doesn't allow IF statements. It does however allow all of these functions: http://docs.moodle.org/20/en/grade/edit/tree/calculation I need a formula that doesn't use IF but will produce the same results as the one below: IFAverage<1 Final Mark = Average*50 IFAverage>=1and<2 Final Mark = 50+(10*Average) IFAverage>=2and<3 Final Mark = 60+(10*(Average - 2)) IFAverage>=3 Final Mark = Average*25 So I want to be able apply this formula to my average mark. So if my average mark was 2.14 then the result I would get after applying the formula would be 61.43. If it was 3.29, my result would be 82.25. I have done some reading and people seem to think that most IF formulas can be calculated using ROUND instead but I wouldn't know where to begin. Also, I don't care how convoluted or long the formula is as noone will ever see it. Many thanks in advance
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.