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