You are here
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-
