Nested IFs or using OR and AND, what gives better performance


Hi, I have a module with a few list-formatted line items. These decide how a nested line item in another module is calculated. I noted that changing some of these list-formatted line items causes the model to freeze for about 30 seconds. Has anyone made any tests to see if the use of AND and OR instead of nesting IFs increases performance or if its all the same? Regards David


Best Answer

  • elizabeth_schaf
    It should all be the same. You should not see any noticeable difference between AND/OR.