Letter represents a number

[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

 

[Peo Sjoblom]

Insert>names>define

put

=5

in the refers to and

X

in the names box

--


Regards,


Peo Sjoblom

 

[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 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.