Check sibling questions

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


=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



View Answer


Example 3


View Answer

 Example 4


View Answer

Example 5


View Answer

Learn GST, TDS, Excel (with certification)

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

Made by

CA Maninder Singh

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