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


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



  1. Excel

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 10 years. He also provides Accounts Tax GST Training in Delhi and Pune.