Looking for formula help!!

[cassieb54788867]

So this might be a dumb and simple question but I am attempting to have a letter grade out put based on the results of a different box.

I have a text field that adds together two other fields on the form. (Lets call it Total point demerits) I need a different box (lets call it inspection grade) to out put a letter based on the data from box 1

If total point demerits is <= 10 then inspection grade should be AIf total point demerits is >= 11 &&  <= 20 then inspection grade should be B

If total point demerits is >= 21 && <= 40 then inspection grade should be C

Thank you for your help.

[try67 · Accepted solution]

As the custom calculation script of "inspection grade" enter this code:

var points = Number(this.getField("Total point demerits").valueAsString);
if (points<=10) event.value = "A";
else if (points<=20) event.value = "B";
else if (points<=40) event.value = "C";

I wasn't sure what you wanted to do if the total is zero, or if the field is empty...