How to use an IF OR statement in Excel

In this Excel training video, we’ll look at some of the logical functions in Excel. We’ll look at IF, IF OR (where OR is nested within an IF function), and AND functions, providing you with a comprehensive understanding of how to craft powerful logical statements in your spreadsheets.

Furthermore, we’ve curated a bonus tip featuring the SWITCH function, adding an extra layer of versatility to your logical toolkit. Uncover how SWITCH can simplify complex decision-making processes, providing a dynamic and efficient alternative to traditional IF statements.


Icons used in the video:
☑ ☒

IF OR Formula:

=IF(OR(A1 = 0, B1 = 0), "yes", "no")

The above formula checks cells A1 and B1 to see if either of the values are equal to 0. If either A1 or B1 is equal to 0, the formula will output “yes“, otherwise it will output “no“.

John Gleave

John Gleave has been a researcher, content writer, and senior editor at Business Tech Planet since 2022. John was formerly a data analyst and web designer with expertise in several programming languages, such as JavaScript, JQuery, PHP, CSS, SQL, and more! With a passion for writing and technology, he has now focused his skills on crafting tech guides for BTP. You can connect with John on LinkedIn.

Recent Posts