There appears to be a limit to how many If statements that can be nested in the Name Manger "refers to" box. It appears that number is 4 nested If statements. Is there any work around this limitation.
I know a regular formula now has a huge increase in nested if statements, but in the name manager function, there seems to have been failure to include the same increase in if statements.
I have never used the choose function, I will try that, it seems to be more flexible