M any use Excel for basic tables, but you need to go beyond simple sums. If your formulas are getting clunky, conditional ...

The test's outputs may also incorporate formulas and function statements of their own. For instance, to calculate pay for an employee who receives $20 per hour, your IF statement might look like ...

For an F in this example (not shown in the screenshot), the Logical_test5 was A3>0 (the cutoff value for the lowest letter grade should be the lowest possible percentage grade.) Another option is to ...