Letter represents a number

  • Thread starter Thread starter JRD920
  • Start date Start date
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
 
Insert>names>define

put

=5

in the refers to and

X

in the names box

--


Regards,


Peo Sjoblom
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW CAN A LETTER IE A ,B OR C REPRESENT A NUMBER IE 0.5 OR 2 ETC.. 2
How to add up letters to equal a number value. 1
sum function 4
Dynamic Sum Array Formula Input Help 3
How do I get a number or letter to represent cell contents? 2
Excel: I want to assign numeric values to letters in a speradsheet 3
Change 3 letter text string to a number string 3
How to type each letter of the alphabet automatically in a specific color in Word? 0

Back
Top