Grades using If statements

Grades using If statements

by Mark Brodie -
Number of replies: 1

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