Request another set of eyes for nested conditional statement exemption [solved]
paotrader
New Altair Community Member
I have been staring this problem for the past several hours with no avail...In the generator attribute operator I have this expression:
IF(USDollar >= 0,IF(Euro >= 0,IF(Euro > USDollar,Euro/USDollar,-Euro/USDollar),Euro/USDollar),IF(Euro <= 0,IF(Euro<USDollar,-Euro/USDollar,Euro/USDollar),-Euro/USDollar))
The formula works in excel but I keep getting an exception in RM.
Any help on this is appreciated...Paolo
Found the solution to the problem RM does not accept capital "IF" only "if" in its statement....
IF(USDollar >= 0,IF(Euro >= 0,IF(Euro > USDollar,Euro/USDollar,-Euro/USDollar),Euro/USDollar),IF(Euro <= 0,IF(Euro<USDollar,-Euro/USDollar,Euro/USDollar),-Euro/USDollar))
The formula works in excel but I keep getting an exception in RM.
Any help on this is appreciated...Paolo
Found the solution to the problem RM does not accept capital "IF" only "if" in its statement....
Tagged:
0