Home |
Search |
Today's Posts |
#1
|
|||
|
|||
GPA formula
How can I create a formula to take a grade and have it displayed as a GPA?
|
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |