How To Use The OR Function Explained - How To Test Multiple Conditions - If Any Condition Is True скачать в хорошем качестве

How To Use The OR Function Explained - How To Test Multiple Conditions - If Any Condition Is True

In this video we discuss how to use the OR function to test if any, of multiple, conditions is true. We go through several examples using numbers, formulas and text strings Transcript/notes The OR function in excel allows us to check if any of the conditions, that we input are true. For instance, here in cell C4 is the value of 14. We are going to use the OR function in cell D4 to check if cell C4 is greater than 100. To do this, you start by left clicking on cell D4, so it is highlighted. Next, we type an equals sign, then we type in the letters or. Now, in the drop down box, left double click on or. From here we need to input the condition, to do this we left click on cell C4, and next we type in a greater than symbol, then we type in 100, then we type in a closed parenthesis. And to finish, we hit the enter key, and we have an output of false, because 14 is not greater than 100. I’ll use the fill handle to fill in the rest of the column, and you can see the true or false outputs. Now, in cell E4, I have the opposite set up, our condition is, is cell C4 less than 100. I will hit the enter key and we have a result of true. Again, I’ll use the fill handle to fill in the rest of the column. You can also use text in an Or function, here in cell F4, I have the condition does cell B4 equal the text electronics space tv, but the text must be surrounded by quotation marks and spacing must be accurate, but capitalization does not. I hit the enter key, and you see we get a result of false. If I use the fill handle and pull down you can see the only true output is in cell F8, as that is a match. Now here, in cell G4, there are 2 conditions, the first is does cell B4 equal the text electronics, and the second is, is cell C4 greater than or equal to 100. So, if either of these 2 conditions are true, the output will be true. I hit the enter key and we get a result of false. I use the fill handle, and you see we have 4 true outputs, where this is the case. One last example. We can also use a formula in a condition. Here in cell I4, there are 2 conditions, the first is, is cell H4 greater than cell C4, is the cost of the sale greater than the sale. And the second condition has a formula, is cell C4 times 10 greater than 1500. So again, if either of these are true, there will be an output of true. I hit the enter key and we get a result of false, as neither condition is true. I use the fill handle to fill in the rest of the column, and you can see there are 3 rows where this is true. Chapters/Timestamps 0:00 What does the OR function do in excel? 0:10 Example how to use the OR function in excel 1:07 How to use text in an OR function 1:35 How to use multiple conditions in an OR function 2:00 How to use a formula in an OR function