0
You use the OR criteria when you want to be able to give a choice of options. Say you have a list of people working in different departments and you want to list people working in the Accounts department or the Sales department, then you would use the OR statement. You could be looking for people who are widowed or divorced from your marital status field as another example. So when you have 2 or more allowable criteria on the one field, you can use the OR criteria. It can also be used across different fields. It depends on what you want to do. If you use it carefully, it is very powerful.
The or is used when one or another criteria needs to be true, but not necessarily all. If not all criteria needs to be true, then you can use an or to test them. I you were looking at two exam marks and only one or other needs to be passed to get an overall pass, you could use an OR function in conjunction with an IF to check. Say the two marks are in cells B2 and C2 and the pass mark is 40%, then you could do this:
=IF(OR(B2>=40%,C2>=40%),"Pass","Fail")
Add your answer:
Earn +20 pts
What is criteria range?
The Criteria Range is a range of cells that hold cells from which criteria are tested for functions in Excel.
What is a good sentence for criteria?
Students in school must follow certain criteria to excel in their education.
What are conditions that you specify in an Excel function called?
Criteria
What is the difference between constraints and criteria?
A constraint has a limit as for criteria: to end a loop Excel Questions
What condition requires that only one of the selected criteria be true for a record to be displayed in Excel?
It is when you are using an OR condition, which in Excel can be implemented through an OR function, or in an Advanced Filter by listing the criteria on different rows.
What logical condition finds records matching both listed criteria in excel?
And
In Microsoft Excel when you filter data it shows only data that meets certain criteria?
Yes. Filtering data allows you to see on certain parts of it, based on the criteria you have specified. It is one of the things that a database does, but Excel can also do.
What excel feature locates rows in a table that meet a criteria?
Filter and its associated command Autofilter.
What function is used to total table values that meet a specified criteria in Excel?
The SUMIF function.
What is the name of a function in Excel that adds data that matched two or more criteria?
The SUMIFS function.
What is the Excel feature that will hide all rows in a list except those that meet specified criteria?
Filter
What are three things you can ask Excel to do?
Sort data. Make decisions based on criteria. Find the highest value out of a list of numbers. There are a huge amount of other things that can be done with Excel. It is a very versatile application.Sort data. Make decisions based on criteria. Find the highest value out of a list of numbers. There are a huge amount of other things that can be done with Excel. It is a very versatile application.Sort data. Make decisions based on criteria. Find the highest value out of a list of numbers. There are a huge amount of other things that can be done with Excel. It is a very versatile application.Sort data. Make decisions based on criteria. Find the highest value out of a list of numbers. There are a huge amount of other things that can be done with Excel. It is a very versatile application.Sort data. Make decisions based on criteria. Find the highest value out of a list of numbers. There are a huge amount of other things that can be done with Excel. It is a very versatile application.Sort data. Make decisions based on criteria. Find the highest value out of a list of numbers. There are a huge amount of other things that can be done with Excel. It is a very versatile application.Sort data. Make decisions based on criteria. Find the highest value out of a list of numbers. There are a huge amount of other things that can be done with Excel. It is a very versatile application.Sort data. Make decisions based on criteria. Find the highest value out of a list of numbers. There are a huge amount of other things that can be done with Excel. It is a very versatile application.Sort data. Make decisions based on criteria. Find the highest value out of a list of numbers. There are a huge amount of other things that can be done with Excel. It is a very versatile application.Sort data. Make decisions based on criteria. Find the highest value out of a list of numbers. There are a huge amount of other things that can be done with Excel. It is a very versatile application.Sort data. Make decisions based on criteria. Find the highest value out of a list of numbers. There are a huge amount of other things that can be done with Excel. It is a very versatile application.
