Is there a way to write an Excel-like IF statement to compute letter grades based on the value of a grade item? For example, if the grade item is Points can one write a formula like
If points >= 1800 grade = 'A'
if 1750 <= points < 1800 grade = 'A-'
if 1700 <= points < 1750 grade = 'B+'
else if 1500 <= points < 1700 grade = 'B'
and so on.
We are using 2.2.3.
Thanks,
Mark