IF formulas

P

Paul Golden

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(B10="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. :-((
 
G

Gary''s Student

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)
 
Top