FORMULA HELP

  • Thread starter Thread starter B.B
  • Start date Start date
B

B.B

I am cant get this to work, I need a formula so cell A1 will show 1 if cell
A2 is A, 2 if B and 3 if C
thanks to all
 
Maybe...

=code(upper(a1))-64

B.B said:
I am cant get this to work, I need a formula so cell A1 will show 1 if cell
A2 is A, 2 if B and 3 if C
thanks to all
Click to expand...
 
How about using some "IF" statements as follows:
=IF(A2="A",1,IF(A2="B",2,IF(A2="C",3,"")))

If A2 does not equal A, B or C, then the cell will be blank.

Dave's formula is better...
 
Sorry, this was not what you asked for. I'll give it another try:
=MATCH(A2,{"A","B","C",""})
This will result in 1,2 or 3 for one of the characters in the array, and 4
for all other characters. It's not case sensitive. It results in an error if
A2 contains a numeric value.

Joerg
 
Dave,

What a clever way of doing this ! I was thinking of nested If's but this is
much simpler.


Rob Lepper
 
You must log in or register to reply here.

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

data validation list 17
Show other cell if blank 5
Figuring out a lengthy formula. Probably quite simple... 3
Excel Need Countifs Formula Help 0
Building closed workbook file path within an Index Function 6
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
If formula and Data Validation parallely 1
convert a number to letter 2

Back
Top