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

Options
PrevContributor
PrevContributor
in Modeling

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

Tagged:

Best Answer

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

Categories