LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default I need to use more than 7 formulas inside each other

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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2 cells inside of one Dumber than a pocket full of rocks New Users to Excel 2 July 3rd 06 11:20 PM
Input box inside a macro Drummy Excel Discussion (Misc queries) 3 June 7th 06 10:49 AM
add inside borders Reney Excel Discussion (Misc queries) 3 November 11th 05 02:53 PM
Using a value from a cell inside a formula! marsupilami Excel Discussion (Misc queries) 5 August 24th 05 07:06 AM
trying to email .xla inside/with .xls jrd269 Excel Discussion (Misc queries) 3 June 2nd 05 03:58 PM


All times are GMT +1. The time now is 05:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"