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

G2 X =AND(E2>=90) A D E G H Net Worth (Dollars) D&B Composite Credit Appraisal (1 Best) D&B PAYDEX (100 Best) F D&B Stress Risk Class (1 Best) Rule #1 Rule #2 Rule #3 1 B Previous Experience Grade Satisfactory Unsatisfactory Satisfactory None Unsatisfactory Bidder 1 2 Ribba Technology 3 TDR Corporation 4. ComputerX 5 Exceed WR 6 Roberts Inc. 2 1 00 von W NA Al $ $ $ $ $ 5,000,000 286,000 4,560,000 1,089,000 23,459,000 1 89 79 87 45 68 FALSE FALSE FALSE FALSE FALSE 3 1 2 TRUE FALSE TRUE FALSE TRUE TRUE TRUE TRUE TRUE FALSE 3 2 7 8 Do any of the bidders meet the rule? 9 10