Using Programmed Formulas in Excel

A NESTED formula that converted a numerical mark to a letter grade which is used at Deakin to create letter grades of High Distinction, Distinction, Credit, Pass, and Fail is outlined. Spreadsheet programming can handle words as well as formulas and numbers. Spreadsheet programming = well-formed formulas + logic + mathematics operations + learning.