I'm trying to do a spreadsheet function where I need to assign numerical
values to a letter. Like calculating your collge GPA. A = 4, B=3, C=2, D=1,
F=0. Can I do that?
I'm trying to do a spreadsheet function where I need to assign numerical
values to a letter. Like calculating your collge GPA. A = 4, B=3, C=2, D=1,
F=0. Can I do that?
For example, paste this to any cell except A1 and enter letter grades in A1:
=VLOOKUP(A1,
{"A+",4.5;"A",4;"B+",3.5;"B",3;"C+",2.5;"C",2;"C-",1.5;"D",1;"F",0}, 2, 0)
Regards,
Greg
"Bob1023" wrote:
> I'm trying to do a spreadsheet function where I need to assign numerical
> values to a letter. Like calculating your collge GPA. A = 4, B=3, C=2, D=1,
> F=0. Can I do that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks