| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formulas
I'm wanting to continue this function all the way to "Z" and "9". This is
used to quickly cypher names for phone pad input. It takes 4 formulas to achieve this since Excel only allows 7 IF functions. =IF(B10="A","2",IF(B10="B","2",IF(B10="C","2",IF(B 10="D","3",IF(B10="E","3",IF(B10="F","3",IF(B10="G ","4",IF(B10="H","4")))))))) I've completed all 4 formulas but I'm wanting to display the result under the letter without going 4 deep and/or having blanks (using conditional format). NAME: z TELEPHONE NUMBERS: FALSE FALSE FALSE 9 I need either solution: IF function or a way to display results by suming the 4 formulas. I hope this makes sense. :-(( |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formulas
Use VLOOKUP with a table.
Jerry "Paul Golden" wrote: I'm wanting to continue this function all the way to "Z" and "9". This is used to quickly cypher names for phone pad input. It takes 4 formulas to achieve this since Excel only allows 7 IF functions. =IF(B10="A","2",IF(B10="B","2",IF(B10="C","2",IF(B 10="D","3",IF(B10="E","3",IF(B10="F","3",IF(B10="G ","4",IF(B10="H","4")))))))) I've completed all 4 formulas but I'm wanting to display the result under the letter without going 4 deep and/or having blanks (using conditional format). NAME: z TELEPHONE NUMBERS: FALSE FALSE FALSE 9 I need either solution: IF function or a way to display results by suming the 4 formulas. I hope this makes sense. :-(( |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formulas
No IFs are required. Try:
=CHOOSE(CODE(B10)-64,2,2,2,3,3,3,4,4,4,5,5,5,6,6,6,7,7,7,7,8,8,8,9,9 ,9,9) -- Gary's Student "Paul Golden" wrote: I'm wanting to continue this function all the way to "Z" and "9". This is used to quickly cypher names for phone pad input. It takes 4 formulas to achieve this since Excel only allows 7 IF functions. =IF(B10="A","2",IF(B10="B","2",IF(B10="C","2",IF(B 10="D","3",IF(B10="E","3",IF(B10="F","3",IF(B10="G ","4",IF(B10="H","4")))))))) I've completed all 4 formulas but I'm wanting to display the result under the letter without going 4 deep and/or having blanks (using conditional format). NAME: z TELEPHONE NUMBERS: FALSE FALSE FALSE 9 I need either solution: IF function or a way to display results by suming the 4 formulas. I hope this makes sense. :-(( |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy worksheet to a new workbook with formulas .... but new file not point to old one | Excel Discussion (Misc queries) | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Hybrid Mode
