AnsweredAssumed Answered

Help with IF (&& ||) Statement

Question asked by bimi82 on Jun 5, 2017
Latest reply on Jun 5, 2017 by bimi82



Please help with the following:


if(Currency=="€ - Euro" || Currency=="$ - Dollar", Amount/Rate, Amount) && if(Rate==0, Amount)



If the Rate equals ZERO then show Amount figure otherwise If Currency equals Euro or Dollar then calculate Amount * Rate otherwise show Amount figure 



in other words; I like the calculated field to show the entered amount figure if the Rate is 0 and Currency is £

otherwise it should divide Amount by Rate



Purpose is to show the amount in £ for the requested euros.