can i get a letter to be calculated in a worksheet

J

JulieD

Hi

Jason answered a similar question posted about 1.5 hrs before yours this
way:
----------

=IF(A1="Y",5,IF(A1="N",2,""))

If you have a lot of letters you need to convert, then
I'd suggest creating a table and using VLOOKUP. See here
for a tutorial:

http://www.contextures.com/xlFunctions02.html

HTH
Jason
Atlanta, GA

-------------

if this isn't what you're looking for, please repost with more details in
the message body of your post as to what you're actually trying to achieve.

Cheers
JulieD
 
D

Doug

Look at the CHAR and CODE worksheet functions. Here are some calculations I
did:

=CODE("D")
=CHAR(J5+66)
 

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

Top