$\backslash$table$[[$A$,$B$,$C$,$D$,$E$,$F$,$G$,H,1,$J$],[$Concord Pro Shop,,,,,$10,000,000,4A,1,91,1],[$Everything Golf,$25,000,15,221,9,483,2,899,1,250,000,3A,3,76,1],[$Lake Pro Shops,$42,000,80,498,81,126,0,2,100,000,3A,2,87,1],[$Mars DepL Store,$27,000,35,354,20,666,0,213,000,$BB$,3,94,1],[$RG Bradley,$46,000,90,970,18,343,0,2,300,000,3A,1,21,1],[$RX for Sports,$15,000,5,663,3,014,0,750,000,2A,1,59,1],[$School Sports Supply,$45,000,50,278,32,338,0,2,250,000,3A,3,91,1],[$Ski World,$26,000,25,864,28,154,0,300,000,$BA$,2,82,1],[$Sneaker Kingdom,$45,000,40,157,25,379,0,2,250,000,3A,2,71,1],[$Sports & Stuff,$15,000,15,898,14,732,14,383,450,000,$BA$,1,67,1],[$Toy Kingdom,$22,000,10,073,1,047,0,1,100,000,3A,3,14,1],[$Under the Sea,$45,000,95,411,64,418,0,150,000,$CB$,4,79,2],[$US Olympic Team,$20,000,5,621,6,171,0,1,000,000,3A,1,87,1],[$WWW Sports inc.,$100,000,60,009,60,354,0,500,000,000,5A,2,97,1],[$Zip & Sons,$10,000,15,490,22,760,0,620,000,1A,2,96,1]]$

Add formulas in cells highlighted in blue

Rule #$1$: Display TRUE for hastomer that has a past due balance that is less than $20\%$ of this year's total sales, otherwise FALSE

Rule #$2$: Display TRUE for a customer that has either a composite credit appraisal value of $1$ or a PAYDEX score over $80,$ otherwise FALSE

For Final Recommendation $($col N$)$

Automatically reject if none of the approval rules are met, or only Rule #$2$ & Rule #$3$ are met.

Suggest a further evaluation if one of the following rules are met:

i$)$ TRUE for only Rule #$3$;

ii$)$ A FALSE value for Rule #$3,$ and TRUE for.

a$)$ either Rule #$1$ or Rule #$2,$

b$)$ or both Rule #$1$ & Rule #$2.$

Automatically accept if TRUE for Rule #$3,$ and

i$)$ TRUE for only Rule #$1$;

ii$)$ TRUE for both Rule #$1$ and Rule #$2.\backslash$table$[[$A$,$B$,$C$,$D$,$E$,$F$,$G$,H,1,$J$],[$Concord Pro Shop,,,,,$10,000,000,4A,1,91,1],[$Everything Golf,$25,000,15,221,9,483,2,899,1,250,000,3A,3,76,1],[$Lake Pro Shops,$42,000,80,498,81,126,0,2,100,000,3A,2,87,1],[$Mars DepL Store,$27,000,35,354,20,666,0,213,000,$BB$,3,94,1],[$RG Bradley,$46,000,90,970,18,343,0,2,300,000,3A,1,21,1],[$RX for Sports,$15,000,5,663,3,014,0,750,000,2A,1,59,1],[$School Sports Supply,$45,000,50,278,32,338,0,2,250,000,3A,3,91,1],[$Ski World,$26,000,25,864,28,154,0,300,000,$BA$,2,82,1],[$Sneaker Kingdom,$45,000,40,157,25,379,0,2,250,000,3A,2,71,1],[$Sports & Stuff,$15,000,15,898,14,732,14,383,450,000,$BA$,1,67,1],[$Toy Kingdom,$22,000,10,073,1,047,0,1,100,000,3A,3,14,1],[$Under the Sea,$45,000,95,411,64,418,0,150,000,$CB$,4,79,2],[$US Olympic Team,$20,000,5,621,6,171,0,1,000,000,3A,1,87,1],[$WWW Sports inc.,$100,000,60,009,60,354,0,500,000,000,5A,2,97,1],[$Zip & Sons,$10,000,15,490,22,760,0,620,000,1A,2,96,1]]$

Add formulas in cells highlighted in blue

Rule #$1$: Display TRUE for hastomer that has a past due balance that is less than $20\%$ of this year's total sales, otherwise FALSE

Rule #$2$: Display TRUE for a customer that has either a composite credit appraisal value of $1$ or a PAYDEX score over $80,$ otherwise FALSE

For Final Recommendation $($col N$)$

Automatically reject if none of the approval rules are met, or only Rule #$2$ & Rule #$3$ are met.

Suggest a further evaluation if one of the following rules are met:

i$)$ TRUE for only Rule #$3$;

ii$)$ A FALSE value for Rule #$3,$ and TRUE for.

a$)$ either Rule #$1$ or Rule #$2,$

b$)$ or both Rule #$1$ & Rule #$2.$

Automatically accept if TRUE for Rule #$3,$ and

i$)$ TRUE for only Rule #$1$;

ii$)$ TRUE for both Rule #$1$ and Rule #$2.$