Custom Formula

Custom Formula

Hi, 

I need to create this formula on zoho creator:

if(input.IVA.contains(“SIM”) && input.IRS.contains(“SIM”))

{

(input.ValorTotal*(input.ValorIVA))-(input.ValorTotal*(input.ValorIRS));

}

else if(input.IVA.contains(“SIM”) && input.IRS.contains(“NAO”))

{

(input.ValorTotal*(input.ValorIVA));

}

else if(input.IVA.contains(“NAO”) && input.IRS.contains(“SIM”))

{

(input.ValorTotal-(inoutValorTotal*input.ValorIRS));

}

else

{

(input.ValorTotal);

}


I don´t know you how have to do...


any help?