you will need to use "if" statements. What type of grade format are you
using in the spreadsheet?

The in-line help will explain the syntax for the statement as you type it.
You will need to link multiple if statements by starting new ones in the area
for the false parameter.

Post what type of data you have and I will do my best to write a formula for
you.

"ladyrosemerry" wrote:

How can I create a formula to take a grade and have it displayed as a GPA?