Please answer this question using the data in "Data Set 1".

If an item is "Blue" in colorOR"Large" in size, its "Promotion Unit Price" is calculated asUnit Price * 0.5 + 500. Otherwise, the Promotion Unit Price of the item is the same as its unit price.

How many different products have a"Promotion Unit Price" that are more than $5000?

Hint: One possible approach to find the answer is as follow:

1. In a new column, use IF() and OR() functions together to calculate the new unit price. (Use Google to search forExcel "OR Function" "IF Function"for manual or examples).
2. Use COUNTIF() to count the number of Promotion Unit Price that met the condition specified in the question.