1. Excel
  2. If Command
Check sibling questions

Simple If Command

Last updated at Dec. 13, 2024 by Teachoo

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

 

View answer

 

 

Download Excel File And Try

if-command-assignmen-1.xlsx
 

Example 2

 

View answer

 

Example 3

 

View answer

 Example 4

 

View answer

Example 5

 

View answer

  1. Excel

    2. If Command

    Concatenate →
Concatenate →
Accounts Tax
Excel

About the Author

CA Maninder Singh

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