Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 54
Default nest more than 7 function

how can i nest more than 7 IF funcyion in formula bar in office 2003 ?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 896
Default nest more than 7 function

http://www.cpearson.com/Excel/nested.htm

On 2 Cze, 10:25, aditya wrote:
how can i nest more than 7 IF funcyion in formula bar in office 2003 ?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default nest more than 7 function

Aditya

Refer http://www.cpearson.com/excel/nested.htm
--
If this post helps click Yes
---------------
Jacob Skaria


"aditya" wrote:

how can i nest more than 7 IF funcyion in formula bar in office 2003 ?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default nest more than 7 function

No can do in 2003. You'd need to use Excel 2007, or to restructure your
formula. What are you trying to do?
--
David Biddulph

"aditya" wrote in message
...
how can i nest more than 7 IF funcyion in formula bar in office 2003 ?



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,651
Default nest more than 7 function

On Tue, 2 Jun 2009 01:25:01 -0700, aditya
wrote:

how can i nest more than 7 IF funcyion in formula bar in office 2003 ?


You cannot. That is a hard limit.

If you post details on exactly what you want to do, there are likely to be some
effective alternatives.
--ron
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
How to nest a left function within a sumif function? LisaK Excel Worksheet Functions 2 April 23rd 23 11:46 AM
Nest IF function Len Excel Worksheet Functions 6 June 19th 08 02:45 AM
HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION CHAIM Excel Worksheet Functions 1 July 27th 05 09:10 PM
Is it possible to nest more than 7 arguments in one function? Summer Scobell Excel Discussion (Misc queries) 3 July 22nd 05 12:52 AM
HOW DO I NEST MORE THAN 1 IF FUNCTION? Rochelle B Excel Worksheet Functions 2 April 27th 05 02:28 PM


All times are GMT +1. The time now is 01:15 PM.

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

About Us

"It's about Microsoft Excel"