LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick
 
Posts: n/a
Default Nested If Limit

I need to exceed the 7 nested function limit to extend the following formula:

=IF(RANK(Q$159,$C$159:$S$159)=1,"Leader",IF($C$160 =1,$Q$159-$C$159,IF($E$160=1,$Q$159-$E$159,IF($G$160=1,$Q$159-$G$159,IF($I$160=1,$Q$159-$I$159,IF($K$160=1,$Q$159-$K$159,IF($M$160=1,$Q$159-$M$159)))))))

with this,

IF($O$160=1,$Q$159-$O$159),IF($S$160=1,$Q$160-$S$160)

This formula (modified by column) is used for each player in a NASCAR
fantasy league spreadsheet that tracks 9 players total points (Row 159), and
ranks them (Row 160). It determines who is the "Leader" and then subtracts
the players points from the "Leaders" points which is then displayed as -XXX
points behind the leader.

The original formula worked fine until this year when two more people joined
our league. It was then that the 7 nested functions limit stopped my
spreadsheet from working.

I don't know if VBA is the answer or some other worksheet function. I know
next to nothing about VBA but would appreciate any suggestions that would
help me solve this problem. I hope this description is clear, if not let me
know and I will try to clarify it. 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
Exceeding the limit for Nested IFs Beard Excel Worksheet Functions 5 January 13th 06 06:12 PM
Max limit of 7 nested loops Subu Excel Worksheet Functions 2 May 28th 05 02:14 PM
how can I exceed the nested if fuction limit mgdye Excel Discussion (Misc queries) 5 January 30th 05 02:09 PM
how can I exceed the nested if fuction limit Mike Excel Discussion (Misc queries) 0 January 30th 05 12:17 AM
Nested IF limit or Open parentheses limit Fred Excel Discussion (Misc queries) 5 December 23rd 04 03:34 PM


All times are GMT +1. The time now is 08:10 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"