IF function decision tree - best practices

[DashboardNovice]

1. Not in the attached example, but in general, if you are using a nested IF, should the nested IF be in the TRUE portion of the IF function or the FALSE portion or does it not matter?

2. I created a decision tree. Each yellow box represents an IF condition. On rows 10-11, I have a nested IF in the TRUE portion and another one in the FALSE portion of the IF statement on row 3-4. Is there any way to avoid this? Is this bad practice?

 

[bosco_yip]

Q1: Is there any way to avoid this?

Ans1: Pls check with and learn LOOKUP function family, like: Index/Match, Vlookup, Lookup, Offset......

Q2: Is this bad practice?

Ans2: Yes