How to Solve if there are more than 2 values possible in one cell or column?

It is done by using Nested if i.e. If in If Command

####
**
How to Apply Nested if
**

Apply Simple if Command

**
= If(Write Condition,Yes Value if condition is true,No Value if Condition not true)
**

In No Value above, put another if as follows

**
= If(Write Condition,Yes Value if condition is true,if(Write Condition2,Yes value if condition 2 satisfied,No Value if Condition 2 not satisfied)
**

**
Download Excel File And Try
**

**
Example 1
**

2 Conditions

**
Example 1
**

3 Conditions

**
Example 1
**

4 Conditions

**
Example 1
**

5 Conditions

**
Example 2
**

2 Conditions

**
Example 2
**

3 Conditions

**
Example 2
**

4 Conditions

**
Example 2
**

5 Conditions

**
Example 3
**

2 Conditions

**
Example 3
**

3 Conditions

**
Example 3
**

4 Conditions

**
Example 3
**

5 Conditions

**
Example 4
**

2 Conditions

**
Example 4
**

3 Conditions

**
Example 4
**

4 Conditions

**
Example 4
**

5 Conditions

**
Example 5
**

2 Conditions

**
Example 5
**

3 Conditions

**
Example 5
**

4 Conditions

**
Example 5
**

5 Conditions

-ea-