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

 

View Answer

 

 

Download Excel File And Try

 

Example 2

if3.png

 

View Answer

 

Example 3

 

View Answer

 Example 4

 

View Answer

Example 5

 

View Answer

Get live Maths 1-on-1 Classs - Class 6 to 12

Ask a doubt
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 13 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.