Rule #1: Consider a bidder if its D&B PAYDEX score is at least 90. Rule #2: Consider a bidder if all of the following criteria are met: The bidders D&B PAYDEX score is greater than 65. The bidders D&B Composite Credit Appraisal value is less than or equal to 2. The bidders Net Worth is greater than $500,000. Rule #3: Consider a bidder if any of the following criteria are met: The bidders D&B Stress Risk Class is equal to 1. The bidders Previous Experience Grade is Satisfactory. 4. In column G, calculate whether or not (TRUE/FALSE) the various bidders meet the criteria for Rule #1. Do not use an IF statement. In column H, calculate whether or not (TRUE/FALSE) the various bidders meet the criteria for Rule #2. Do not use an IF statement. In column I, calculate whether or not (TRUE/FALSE) the various bidders meet the criteria for Rule #3. Do not use an IF statement. 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.

Please attach a detailed screenshot of the formula thanks

A1 for Bidder E F G D D&B Composite Credit Appraisal (1 Best) Net Worth (Dollars) Bidder D&B PAYDEX (100 Best) Rule #1 Rule #2 Rule #3 1 2 Ribba Technology 3 TDR Corporation 4 ComputerX 5 Exceed WR 6 Roberts Inc. 7 B Previous Experience Grade Satisfactory Unsatisfactory Satisfactory None Unsatisfactory D&B Stress Risk Class (1 Best) 1 1 3 $ $ $ $ $ 5,000,000 286,000 4,560,000 1,089,000 23,459,000 1 2 1 3 2 89 79 87 45 68 1 2 8 Do any of the bidders meet the rule? 9 10 A1 for Bidder E F G D D&B Composite Credit Appraisal (1 Best) Net Worth (Dollars) Bidder D&B PAYDEX (100 Best) Rule #1 Rule #2 Rule #3 1 2 Ribba Technology 3 TDR Corporation 4 ComputerX 5 Exceed WR 6 Roberts Inc. 7 B Previous Experience Grade Satisfactory Unsatisfactory Satisfactory None Unsatisfactory D&B Stress Risk Class (1 Best) 1 1 3 $ $ $ $ $ 5,000,000 286,000 4,560,000 1,089,000 23,459,000 1 2 1 3 2 89 79 87 45 68 1 2 8 Do any of the bidders meet the rule? 9 10