Using the logical functions: =IF(), =SUMIF(), =SUMIFS(), =COUNTIF(), =COUNTIFS(), =ISERROR(), =IFERROR() to answer the questions below

1. Is the smallest product number less than 563? Answer Yes or No.

2. How many products have a cost less than $3.22 and sales price higher than $1.45?

3. What is the total demand for products with demand over 2200?

4. How many products have a product number greater than or equal to 2282?

5. What is the total demand for products with prices less than $2.1 and costs less than $1.84?

1 3 4 1 2 3 Product Name Alpha Beta Delta Gamma Omega Pi O M N O P A. 2 Product Number 307 1132 1866 7838 5462 2282 Cost $1.52 $1.81 $1.42 $2.36 $2.67 $1.08 $1.36 $1.02 5 Demand 2740 1300 2350 600 1390 Sales Price $4.05 $2.58 $3.56 $3.37 $3.65 $2.49 $3.31 $3.47 560 8286 Theta Zeta 2870 2320 62