Hello Raymond, Not sure about the limit, I have quite a few nested IF formulas that with more than 5 IFs and one that has 10+. I also have some calculations based on the result included in the nested IF formulas and haven’t encountered any issues. Would be good to know if there is a hard limit. Cheers Damien

Same here. No issues in an 8 nested If.

I don’t know of any limit. However there probably comes a point where it’ll look like an actuary’s SQL thread and that’s not something I want to think about troubleshooting.

I’ll be testing the limits. I’ll let you know. All the if statements are identical except the comparison word so hopefully it will be easy enough to keep organized

I wish you the best Skuidward. I’ll be curious to see what you find. Please keep us updated with what you find