It is normally used when there are  2 values Possible in one Column or Row.

Formula

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

 

Example 1

Simple If Command  - If Command

 

-a-

excel1.png

-ea-

 

 

Download Excel File And Try

 

Example 2

if3.png

 

-a- 

NEW PPT Q2 IMAGE CONDITION 1.png

-ea-

 

Example 3

 

-a-

excel3.png

-ea-

 Example 4

 

-a-

excel4.png -ea- 

Example 5

 

-a-

NEW PPT Q5 IMAGE CONDITION 1.png

-ea-

  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 6 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com .
Jail