Malformed If Statement

[GabrielGomes9]

Hi everyone, 
I can't find the error in the formula can you please help?

IF [3D]="431" THEN 0 ELSE
IF [3D]="453" THEN 0 ELSE
IF [Aquisição do ano?]="Y" THEN [ Movim.ValContáb]*(1/[Vida Útil em 2022]/12)*(11-[Mês alienação])ELSE
IF [Classificação PwC]="Totalmente Depreciado" THEN 0 ELSE
IF [ Fim val.cont.]= 0 THEN [ Início val.cont] ELSE (1/[Vida Útil em 2022]/12)*10*[ Val.aquis.acum.] ENDIF ENDIF ENDIF ENDIF

[caltang · Accepted solution]

IF [3D]="431" 
THEN 0 
ELSEIF [3D]="453" 
THEN 0 
ELSEIF [Aquisição do ano?]="Y" 
THEN [ Movim.ValContáb]*(1/[Vida Útil em 2022]/12)*(11-[Mês alienação])
ELSEIF [Classificação PwC]="Totalmente Depreciado" 
THEN 0 
ELSEIF [ Fim val.cont.]= 0 
THEN [ Início val.cont] 
ELSE (1/[Vida Útil em 2022]/12)*10*[ Val.aquis.acum.] 
ENDIF

Try the above.

[caltang · Accepted solution]

@GabrielGomes9 If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

[GabrielGomes9]

Why the error persist?

[harshendra]

@GabrielGomes9 in the ELSE part of the statement, you have three opening parentheses "(" but only two closing parentheses ")". Please update the formula correctly and then your error "Malformed If Statement" should be gone.