Welcome Guest.

1Answers

Excl if function nesting display error

Asked by: Donna Allen 175 views IT October 15, 2018

There is no problem with single-group operations. After the merge nesting, the error will be displayed in individual links!

Ask God to answer!

——————————————————————————————————————

——————————————————————————————————————

=IF(OR(D3="",E3="",F3="",F3="Preliminary Review",F3="Refundable"),"/" ,"")&=IF(E3=6,D3*150,"")&=IF(E3=12,D3*300,"")&=IF(AND(E3=24, OR(F3="Approval",F3="Pending ")), D3*400,"")&=IF(AND(E3=24,OR(F3="Lending", F3="Overdue"), DATEDIF(G3, TODAY(),"Y")<1), D3*400,"")&=IF(AND(E3=24,OR(F3= "Lending", F3="Overdue"), DATEDIF (G3, TODAY(), "Y")>=1), D3*600,"")&=IF(AND(E3) =24,F3="Setting ",DATEDIF(G3,H3,"Y")<1),D3*400,"")&=IF(AND(E3=24,F3="Settle ",DATEDIF(G3,H3,"Y")>=1), D3*600,"")&=IF(AND(E3=36,OR(F3="Approval&q Uot;,F3="to be placed")), D3*300,"")&=IF(AND(E3=36,OR(F3="lending",F3="overdue" ),DATEDIF(G3,TODAY(),"Y")<1),D3*300,"")&=IF(AND(E3=36,OR(F3="lending",F3 ="Overdue"), DATEDIF(G3, TODAY(),"Y")>=1), D3*500,"")&=IF(AND(E3=36,F3=" Settlement ",DATEDIF(G3,H3,"Y")<1), D3*300,"")&=IF(AND(E3=36,F3="clear",DATEDIF (G3, H3, "Y")>=1), D3*500,"")

—————————————————— ——————————————————————

————————————————————— ———————————————————

=IF(OR(D3="",G3="Return",G3=" Initial review ", E3=""), "/", IF (E3=6, D3*150, IF (E3=12, D3*300, IF(AND(E3=24,OR(G3= "Approval", G3="Pending ",G3="Withdrawal",G3="Overdue",DATEDIF(H3,TODAY(),"Y")<1), D3*400, IF(AND(E3=24,OR(G3="lending",G3="overdue"), DATEDIF(H3,TODAY()," Y")>=1), D3*600, IF (AND(E3=24, G3="clear",DATEDIF(H3,J3,"Y")<1), D3*400, IF(AND(E3=24,G3="clear",DATEDIF(H3,J3,"Y")>=1), D3*600, IF(AND(E3=36,OR(G3= "Approval", G3="Pending ",G3="Withdrawal",G3="Overdue",DATEDIF(H3,TODAY(),"Y")<1), D3*300, IF(AND(E3=36,OR(G3="Approval",G3="Putting ",G3="Withdrawal",G3="Overdue"),DATEDIF( H3, TODAY(), "Y")>=1), D3*500, IF(AND(E3=36,G3="clear",DATEDIF(H3,J3,"Y")<1), D3*300, IF (AND(E3=36, G3="clear",DATEDIF(H3,J3,"Y")>=1), D3*500))))) ))))))

1 Answers

  1. +6Votes  

    Formula 1:

        Obviously “&=” is not allowed

        directly change “&=” to “&” Yes

    Formula 2:

        Exceeds the limit of the number of nested layers of the IF function

    Patrick Martin- October 15, 2018 |