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.
Resources
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“.