Check sibling questions

If + Or Command

Last updated at May 16, 2023 by

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

 If-+Or-Command Assignments.xlsx

 

Example 2

 

Example 3

 

 

Get live Maths 1-on-1 Classs - Class 6 to 12

Book 30 minute class for ₹ 499 ₹ 299
Ask a doubt
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

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