Malformed If Statement

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

Bug

Accepted answers

caltang

IF [3D]="431" 
THEN 0 
ELSEIF [3D]="453" 
THEN 0 
ELSEIF [Aquisi&ccedil;&atilde;o do ano?]="Y" 
THEN [ Movim.ValCont&aacute;b]*(1/[Vida &Uacute;til em 2022]/12)*(11-[M&ecirc;s aliena&ccedil;&atilde;o])
ELSEIF [Classifica&ccedil;&atilde;o PwC]="Totalmente Depreciado" 
THEN 0 
ELSEIF [ Fim val.cont.]= 0 
THEN [ In&iacute;cio val.cont] 
ELSE (1/[Vida &Uacute;til em 2022]/12)*10*[ Val.aquis.acum.] 
ENDIF

Try the above.

caltang

@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/

All comments

caltang

IF [3D]="431" 
THEN 0 
ELSEIF [3D]="453" 
THEN 0 
ELSEIF [Aquisi&ccedil;&atilde;o do ano?]="Y" 
THEN [ Movim.ValCont&aacute;b]*(1/[Vida &Uacute;til em 2022]/12)*(11-[M&ecirc;s aliena&ccedil;&atilde;o])
ELSEIF [Classifica&ccedil;&atilde;o PwC]="Totalmente Depreciado" 
THEN 0 
ELSEIF [ Fim val.cont.]= 0 
THEN [ In&iacute;cio val.cont] 
ELSE (1/[Vida &Uacute;til em 2022]/12)*10*[ Val.aquis.acum.] 
ENDIF

Try the above.

caltang

GabrielGomes9

Why the error persist?

Malformed If Statement.png

Adenikeadeyemi

Thank you - this just saved me sometime.....

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280