I need to use more than 7 formulas inside each other...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello there.

I need to make a cell display different names depending on a number that is
typed on another cell. For example:

Cell B17 is editable and I want the user to type there numbers from 2 to 13,
depending on his own will.

Then, I want cell B18 to display a certain string that is dependable on the
choice made by the use on cell B17. I can do that up to 7 times (after that
Office XP gives an error message), but as you can see, I have 12 different
types of numbers to choose. How can I do it so I don't have to make the text
of the other 5 types be exhibited on a different cell?

Thanks!
 
Back
Top