Bidder List	Previous Experience Grade	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
Ribba Technology	Satisfactory	$ 5,000,000	1	89	1	FALSE	TRUE	TRUE
TDR Corporation	Satisfactory	286,000	2	79	1	FALSE	FALSE	TRUE
ComputerX Assoc.	Satisfactory	4,560,000	1	93	3	TRUE	TRUE	TRUE
Exceed WR	None	1,089,000	3	45	1	FALSE	FALSE	TRUE
Roberts Inc.	Unsatisfactory	23,459,000	2	68	2	FALSE	TRUE	FALSE

In these steps, you will help complete the credit analysis by applying the following set of rules:

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 company's D&B PAYDEX score is greater than 65. The company's D&B composite credit appraisal value is less than or equal to 2. The company's net worth is greater than $500,000. (Net worth values are listed in dollars on the worksheet.)

Rule #3: Consider a bidder if any of the following criteria are met: The company's D&B stress risk class is equal to 1. The company's previous experience grade is Satisfactory.

Question- below

In cell G1O, write a formula to determine if none of the bidders has a TRUE value for Rule #1. Copy this formula across the row to determine if none of the bidders has a TRUE value for Rules #2 and #3. In cell A10, enter an appropriate label for this row.