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

Nested if - If Command

View Answer

  

Example 1

3 Conditions

View Answer

 

Example 1

4 Conditions

View Answer

 

Example 1

5 Conditions

View Answer

 

Example 2

2 Conditions

View Answer

 

Example 2

3 Conditions

View Answer

 

Example 2

4 Conditions

View Answer

 

Example 2

5 Conditions

View Answer

 

Example 3

2 Conditions

View Answer

 

Example 3

3 Conditions

View Answer

 

Example 3

4 Conditions

View Answer

 

Example 3

5 Conditions

View Answer

 

Example 4

2 Conditions

View Answer

 

Example 4

3 Conditions

View Answer

 

Example 4

4 Conditions

View Answer

 

Example 4

5 Conditions

View Answer

 

Example 5

2 Conditions

View Answer

 

Example 5

3 Conditions

View Answer

 

Example 5

4 Conditions

View Answer

 

Example 5

5 Conditions

View Answer
  1. Accounts Tax
  2. Excel
Ask Download

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 8 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com .
Jail