Calculated field with multiple IF/And statement

@sanjeevanith - Here is some documentation on multiple IF statements.

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/if-statements-overview#multiple-if-statements

An IF statement evaluates a condition that results in either TRUE or FALSE. Once the condition is evaluated. So, when you write an IF statement with both TRUE and FALSE values, the evaluation completes after it has processed the condition. To do multiple IF statements you need to leave off a FALSE value so the formula will continue validating conditions. 

@sanjeevanith just checking in! Were you able to get this resolved? If one of the replies above helped—whether it completely solved the issue or simply pointed you in the right direction—marking it as accepted can make it much easier for others with the same question to find a solution. And if you found a different way to fix it, sharing your approach would be a great contribution to the community. Your follow-up not only helps close the loop but also ensures others benefit from your experience. Thanks so much for being part of the conversation!