if, then statements and alpha variables

J

jfav

I want to have Excel return 1 if the value is e and -1 if the value is
w. I can do this with the logical IF statement if the variables are
numbers but it doesn't work if the variables are letters. any
suggestions?
 

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

VBA multiple list of values for variable 1
Visio: copy text of a master shape to User-define Cells (Variable) 0
Mail Merge Directory Conditional Page Break 0
Page numbering with Merged Document and IF statements 1
Incorporating the User Profile location into a document template path 1
Drop down list control value in vba 2
Need Adaptable Macro 9
Using variable defined as As Font 1

Top