Simple If Command

Last updated at August 14, 2026 by

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

if-command-assignmen-1.xlsx
 

Example 2

if3.png

 

View Answer
 
 
 

 

Example 3

 

View Answer
 
 
 

 Example 4

 

View Answer
 
 
 

Example 5

 

View Answer
 
 
 
Remove Ads
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant with 16+ years of practical experience and 20+ years of teaching experience. At Teachoo, he simplifies Accounts, Tax and GST with step-by-step examples so students can apply concepts confidently in exams and real life.

For an uninterrupted learning experience, students can use Teachoo Black to remove ads and focus better.