Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Using More than 7 possibilities in a formula

How do I use more than 7 possibilities in a formula. I know basically you
can't nest more than 7 formulas in one.

Any suggestions would be helpful
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 492
Default Using More than 7 possibilities in a formula

Check out VLOOKUP in help,
Regards,
"saschmeling" wrote in message
...
How do I use more than 7 possibilities in a formula. I know basically you
can't nest more than 7 formulas in one.

Any suggestions would be helpful


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Using More than 7 possibilities in a formula

you can also create a named formula in the name manager, insert further
nesting and include that in the original formula

"saschmeling" wrote:

How do I use more than 7 possibilities in a formula. I know basically you
can't nest more than 7 formulas in one.

Any suggestions would be helpful

Reply
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
Excel/VBA possibilities The Alltime Best Excel Programming 2 April 30th 06 09:18 PM
Thousands of possibilities sharkfoot Excel Discussion (Misc queries) 5 March 27th 06 05:11 AM
Conditional w/ three possibilities MathDoctor Excel Discussion (Misc queries) 4 June 11th 05 03:45 PM
Brackets [] possibilities ? alainB[_17_] Excel Programming 5 May 15th 04 10:50 PM
find the possibilities BlackBlade[_2_] Excel Programming 2 May 5th 04 08:58 AM


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

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"