Interesting error there. It's hard to tell what's causing it. At first I thought it might be conflicting logic, but that doesn't seem to be the case.
If it helps you can separate the formula into lines in the formula bar with ALT+Enter. You could give each If statement it's own line to help pinpoint the error possibly.
|