tried this but cant get it to work
maybe a little more explanation?
If i get it correctly
1. make a chart like:
A 4.0
B+ 3.3
B 3.0
B- 2.7
C+ 2.3
C 2.0
C- 1.7
D 1.0
F 0.0

2. use the lookup function???
3.??


"Don Guillett" wrote:

try this idea
=LOOKUP(F13,{"a","b","c","d";4,3,2,1})
or
=LOOKUP(F13,{"a","b","c","d";4,3,2,1})*4
--
Don Guillett
SalesAid Software

"Mike" wrote in message
...
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.
thanks
mike