Request another set of eyes for nested conditional statement exemption [solved]

paotraderpaotrader Member Posts: 3 Contributor I
edited November 2018 in Help
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....
Sign In or Register to comment.