Mon, 7 May 2007 15:00:01 -0700 from Mike
:
I am trying to substitute letters for number values.
Trying to calculate my GPA while substituting an A for 4.0, (A=4.0) and
B=3.0 ...
I want to be able to see the letter grade in the sheet but be able to
multiply by the umber of credit hours. Like A*4cc=16 The A would equal 4 and
4*4=16
any help would be greatly appreciated.

Put the grade-to-quality-point equivalence in a two-column table, and
use VLOOKUP to access it.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/