|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 16th, 2009, 07:31 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cypher
Good day,
No, I'm not James Bond nor am I a criminal trying to hack into the CIA... Just wanted a hand with a simple cypher if anyone can help. I want to be able to change a series of letters and characters into another for a specific task... E.g. A,B,C = 1 F,G,H = 2 J,K,L = 3 #,$,% = 3 If I enter BHL% I want to see 1234 I tried using IF comands as shown below but I can only nest 7... is there an array or something I can use (I am hopless with VBA so if anyone knows an excel formual I would be grateful)???? =IF(A1="A",1,IF(A1="B",1,IF(A1="C",1,IF(A1="F",2)) )) 
|
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode