Letter represents a number

J

JRD920

I would like to have a letter represent a number and to be able to calculate
to get a sum.

Example X= ".5" = 0.5
 
P

Peo Sjoblom

Insert>names>define

put

=5

in the refers to and

X

in the names box

--


Regards,


Peo Sjoblom
 
G

Gord Dibben

What will you do with the number?

You can't SUM just .5

Maybe count all "x" and divide by 2?

=COUNTIF(Range,"x")/2

Or something else...........?

=LOOKUP(B1,{"A","B","X"},{1.5,1,0.5}) + A1


Gord Dibben MS Excel MVP
 
M

M Kan

If you have a larger list of letter-value combos, you might just want to
create a lookup table and then use a vlookup for the translation.
 
Top