7. In cells G8:I8, use a function to determine whether or not (TRUE/FALSE) any of the bidders meet each of the various rules. Do not use an IF statement.

D E F G H Net Worth (Dollars) D&B Composite Credit Appraisal (1 Best) D&B PAYDEX (100 Best) D&B Stress Risk Class (1 Best) Rule #1 Rule #2 Rule #3 1 89 1 TRUE FALSE 2 1 $ $ $ $ $ 5,000,000 286,000 4,560,000 1,089,000 23,459,000 1 79 87 45 3 FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE TRUE FALSE 3 TRUE FALSE TRUE 1 2 68 2 Do any of the bidders meet the rule