The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Request another set of eyes for nested conditional statement exemption [solved]
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....
0