ClarisWorks offers an If function. I will leave without you. It is what will happen if the logical is met . It is the result when the logical is not met . IF function - converting text to numbers I wanted to make a formula to average a student's writing grades for the year.
Numeric grades are no problem.
But for those who give letter grades, there is a challenge. You cannot put letters in the Average function. It requires numbers. You could change the grade by hand as you worked in a grade book spreadsheet. This seems like a lot of work to me.