Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Good afternoon,
I have this long formula made of "If's" and got an error for too many nesting. I have tried to find in library similar problems and could not exactly find same issue. Could somebody help? Here it is... =IF(and(g6=0,i6=0,$m6=0),"", IF(AND(G60,I6=0,$m6=0),"n/r", IF(and(G6=0,i6=0,$m60),0, IF(and(G6=0,i60,$m6=0),"-0.0", if(AND((G6=i6,$m6=0),"", if(and(g6<i6,$m6=0),-1, IF(G6-I6<$Q6,(G6-I6)/$Q6, IF((G6-I6<$Q6+$R6),1+((G6-I6-$Q6)/$R6), IF(G6-I6<($Q6+$R6+$S6),2+((G6-I6-$Q6-$R6)/$S6), IF(G6-I6<($Q6+$R6+$S6+$T6),3+((G6-I6-$Q6-$R6-$S6)/$T6), IF(G6-I6<($Q6+$R6+$S6+$T6+(4*$V6)),4+((G6-I6-$Q6-$R6-$S6-$T6)/(4*$V6)),(G6-I6)/$M6)))))))))))) -- Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nesting | Excel Worksheet Functions | |||
Nesting | Excel Worksheet Functions | |||
OR Nesting? | Excel Discussion (Misc queries) | |||
IF - Nesting... almost got it - need a bit of help | Excel Worksheet Functions | |||
nesting sum if and | Excel Worksheet Functions |