ExcelBanter - IF formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF formulas (https://www.excelbanter.com/excel-discussion-misc-queries/56964-if-formulas.html)

Paul Golden

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. :-((

Jerry W. Lewis

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. :-((

Gary''s Student

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. :-((

All times are GMT +1. The time now is 07:18 PM.