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