It is used if any of 2 or more conditions fulfilled,there is separate value

and

if not fulfilled,there is separate value

 

=if(or(Condition1,Condition 2),Yes value,No Value)

 

Example 1

If + Or Command - If Command

Download Excel File And Try

 

Example 2

 

Example 3

 

 

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.