Nested IF Formula Limitation

[ben123456]

Hey

i get the nesting limit error when using this beast

=IF(H6=3,J6,IF(H7=1,IF(K8>0.01,SUM((F7-(J4*K7)/G7)+I7,IF(H7=2,IF(K8>0.01,SUM((F7-(J4*K7)/G7)+((F8-(J4*K8)/G8)+I7,IF(H7=3,IF(K8>0.01,SUM((F7-(J4*K7)/G7)+((F8-(J4*K8)/G8)+((F9-(J4*K9)/G9)+I7,IF(H8=1,IF(K8>0.01,SUM((F8-(J4*K8)/G8)+I8,IF(H8=2,IF(K8>0.01,SUM((F8-(J4*K8)/G8)+((F9-(J4*K9)/G9)+I8,IF(H8=3,IF(K8>0.01,IF(K9>0.01,IF(K10>0.01,SUM((F8-(J4*K8)/G8)+((F9-(J4*K9)/G9)+((F10-(J4*K10)/G10)+I8)),IF(H6=3,J6,IF(H7=1,IF(K8>0.01,SUM(((F8-(J4*K8)/G8)+I7,SUM((F8/G8)+I7)),IF(H7=2,IF(K8>0.01,SUM((F7-(J4*K7)/G7)+(F8-(J4*K8)/G8)+I7,SUM((F7/G7)+(F8/G8)+I7),IF(H7=3,(F7-(J4*K7)/G7)+(F8-(J4*K8)/G8)+(F9-(J4*K9)/G9)I7,SUM((F7/G7)+(F8/G8)+(F9/G9)+I7),IF(H8=1,(F8/G8)+I7,IF H8=2,(F8/G8)+(F9/G9)+I7,IF(H7=3,(F10/G10)+(F10/G10)+(F10/G10)+I7)


I need everything on that

 

[mikerickson]

Can you describe, with words, what that formula is supposed to be doing?

 

[shabbyporpoise]

use the

 tags to make your post a little easier to read.  thanks

 

[AlphaFrog]

The 1st IF in your formula is...

=IF(H6=3,J6,...

In the middle of your formula you have another IF(H6=3,J6...

That second IF(H6=3 and the succeeding parts will never have the chance to evaluate.