were going to show you how to use AND and OR functions in Excel 2016.
First, if youre curious you can go ahead under the Formulas tab and click the Logical drop-down menu to see the logical formulas, AND and OR included.
AND and OR are typically used in conjunction with IF statements, so that is what our example will use. First, with the OR, this is our formula: =IF(OR(C3=4, C3=2, True, False. If C3 is equal to four OR if C3 is equal to two then this will result in True, else False.
The AND example looks like such: =IF(AND(C3=4, C4=5, Both True, At least one false. C3 must equal four AND C4 must equal 5 for this to result in true, else either one could be false Date: 2023-07-08
