Hi team. I'm sure that this must have been covered before but I'm stuck.
We keep students grades as A-, B+ etc
and convert these to a numerical value at the end of
each course. I have this part of my spreadsheet working and end up with a total figure (out of
100) for each student. So far so good.
Now I'm trying to take that score and convert it back into a final grade.
Each grade relates to
a range of scores, so 90+ = A+ and so forth. I'm not far from getting it sorted but Excel keeps
rejecting my formula and I'm still a luddite with these things. Here's my formula.
Have I got too many closed brackets on the end, or am I trying to process too many functions
within the one formula? I'm quite new to the darker parts of Excel so be gentle please!