This is my worksheet. I got mark incorrect because of the function I have in Inventory Report doesn't mark the Status correctly.

Inventory Status Report Current Unit Sales Product Inventory Last Week Sell Through Status Item 4 5,040 1793 35.6% Rush Priority Item 14 3,098 1033 33.3% Rush Priority Item 20 1,458 486 33.3% Rush Priority Item 13 187 47 25.1% OK Item 10 428 86 20.1% OK Item 25 1,335 267 20.0% OK Item 23 6,367 1220 19.2% OK Item 1 3,540 590 16.7% OK Item 6 1,404 176 12.5% OK Item 9 2,430 270 11.1% OK Item 16 3,226 358 11.1% OK Item 18 9,356 965 10.3% OK Item 12 5,800 580 10.0% OK Item 19 8,720 872 10.0% OK Item 22 8,454 769 9.1% Cancel Warning Item 3 12,600 1050 8.3% Cancel Warning Item 11 11,673 834 7.1% Cancel Warning Item 21 1,181 79 6.7% Cancel Warning Item 5 5,939 371 6.2% Cancel Warning Item 15 5,058 298 5.9% Cancel Warning Item 8 16, 184 952 5.9% Cancel Warning Item 24 13,122 729 5.6% Cancel Warning Item 7 16,727 797 4.8% Cancel Warning Item 17 3,663 167 4.6% Cancel Warning Item 2 1,142 48 4.2% Cancel WarningAutoSave . OFF 1 Chapter_6_IC_Exercise_3-f2a1 (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 12 AA ag Wrap Text v General ZAY- O. Paste BIU BY OvAv E E Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis E3 X V fx =[F(AND(C3>100, D3>=20%),"Rush Priority", IF(D312%),"OK","Other"))) A B D E G L M N 0 P Q R S T U nventory Status Report Current Unit Sales 2 Product Inventory Last Week Sell Through Status 3 Item 3,540 590 16.7% Other 4 1 1,142 48 4.2% Cancel Warning 5 Item 3 2,600 1050 8.3% Cancel Warning 6 Item 4 5,04 1793 $5.6% Rush Priority 7 Item 5 5,939 371 6.2% Cancel Warning 8 Item 6 1,404 176 2.5% OK 9 Item 7 16,727 797 1.8% Cancel Warning 10 Item 8 6,184 952 5.9% Cancel Warning 11 Item 9 2,430 270 11.1% Other Item 10 428 86 20.1% Other 13 11,673 834 7.1% Cancel Warning 14 Item 12 5,800 580 10.0% Other 15 Item 13 187 47 25.1% Other 16 Item 14 3,098 1033 83.3% Rush Priority 17 5,058 298 5.9% Cancel Warning Item 16 3,226 358 11.1% Other 19 Item 17 3,663 167 4.6% Cancel Warning Item 18 9,356 965 0.3% Other 21 Item 19 3,72 872 10.0% Other 22 Item 20 1,458 486 $3.3% Rush Priority 23 Item 21 1,181 79 6.7% Cancel Warning 24 Item 22 8,454 769 .1% Cancel Warning Item 23 6,367 1220 9.2% Other 26 3,12 729 5.6% Cancel Warning 27 Item 25 1,335 267 20.0% Rush Priority 28 29 30 31 32 33 34 35 36 37 38 AnswerSheet Inventory Report + Ready + 100%