Simple OR

It's now time to practice OR conditions!

You can complete this exercise on DataCamp using in-browser Excel, or locally if you have Excel installed.

Database functions make multiple AND and OR conditions possible within just one function. This is a serious upgrade compared to SUMIFS() or COUNTIFS()!

As a reminder, below we display the syntax of one of these database functions, DAVERAGE() and a brief recap on Criteria Table:

Our criteria for this exercise: Order Item IDs in Seattle (City) or Florida (State).