Hi there!
I am extremely new to FormCalc and scripting and I was wondering if someone can tell me if my query is possible, if so, please help me!
I would like for each time a user enters a number in a cell for the number to change to a letter or vice versa, please see below what I am trying to achieve with this task.
| Score as follows: A; Excellent, B; Good, C |
| English Test | Tutor 1 score | Tutor 2 score |
|---|
| Speaking | A | B |
| Reading | C | B |
| Writing | C | B |
| Forming an argument | B | B |
| English Grade = (Avg. Score) | | |
|
Is this at all possible? Is there another way to do this so that it is easy and the student average grades can be easily generated?
