Calculated field with multiple IF/And statement
@SanjeevaniTh - Here is some documentation on 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.
