Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Exceeding the limit for Nested IFs | Excel Worksheet Functions | |||
Max limit of 7 nested loops | Excel Worksheet Functions | |||
how can I exceed the nested if fuction limit | Excel Discussion (Misc queries) | |||
how can I exceed the nested if fuction limit | Excel Discussion (Misc queries) | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) |