In column H, calculate whether or not (TRUE/FALSE) the various bidders meet the criteria for Rule #2. DO not use an IF statement.

PLEASE SHOW THE FORMULA YOU USED IN COLUMN H!

Rule #2: Consider a bidder if all of the following criteria are met: The bidder's D&B PAYDEX score is greater than 65. The bidder's D&B Composite Credit Appraisal value is less than or equal to 2. A B D G H 1 Bidder Net Worth (Dollars) D&B Composite Credit Appraisal (1 Best) D&B PAYDEX (100 Best) D&B Stress Risk Class (1 Best) 11 #2 Rule #1 Rule #2 Rule #3 1 1 Previous Experience Grade Satisfactory Unsatisfactory Satisfactory None Unsatisfactory 89 79 2 Ribba Technology TDR Corporation ComputerX Exceed WR Roberts Inc. 1 $ $ $ $ $ 5,000,000 286,000 4,560,000 1,089,000 23,459,000 1 87 3 45 1 3 2 68 2 The bidder's Net Worth is greater than $500,000. Rule #2: Consider a bidder if all of the following criteria are met: The bidder's D&B PAYDEX score is greater than 65. The bidder's D&B Composite Credit Appraisal value is less than or equal to 2. A B D G H 1 Bidder Net Worth (Dollars) D&B Composite Credit Appraisal (1 Best) D&B PAYDEX (100 Best) D&B Stress Risk Class (1 Best) 11 #2 Rule #1 Rule #2 Rule #3 1 1 Previous Experience Grade Satisfactory Unsatisfactory Satisfactory None Unsatisfactory 89 79 2 Ribba Technology TDR Corporation ComputerX Exceed WR Roberts Inc. 1 $ $ $ $ $ 5,000,000 286,000 4,560,000 1,089,000 23,459,000 1 87 3 45 1 3 2 68 2 The bidder's Net Worth is greater than $500,000