Spreadsheet: 99414d1298037149-percentage-and-rounding-with-int-and-round-excel-forum
Sheet: Womens Apparel

 |  |  |  |  |  |  |  |  | 0.29 | 0.4 | 0.22 | 0.09 | 0 | Polo/Knits
 |  |  |  |  |  |  |  |  | 0.21 | 0.37 | 0.25 | 0.17 | 0 | Bottoms
 |  |  |  |  |  |  |  |  | 0.23 | 0.37 | 0.3 | 0.1 | 0 | Outerwear
Product Code | Description | Colour | Range | Logo | Tonal / Full Colour | Thread 1 (Jug) | [NAME] (Roundel/Text) | [NAME] | S | M | L | XL | XXL | Total ord |  | WSP | RRP | [NAME] value | [NAME] value
Womens [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Sum
P16525 |  |  |  |  |  |  |  |  | 22 | 30 | 16 | 7 | 0 | 75 |  | 12.08 | 29
P78681 |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 |  | 12.08 | 29
P78682 |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 |  | 12.08 | 29
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 |  | 12.08 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Womens Polos
P16473 |  |  |  |  |  |  |  |  | 11 | 16 | 9 | 4 | 0 |  |  | 15.83 | 38
P16474 |  |  |  |  |  |  |  |  | 15 | 20 | 11 | 4 | 0 |  |  | 15.83 | 38
P16475 |  |  |  |  |  |  |  |  | 15 | 20 | 11 | 4 | 0 |  |  | 15.83 | 38
[NAME] |  |  |  |  |  |  |  |  | 29 | 40 | 22 | 9 | 0 |  |  | 15.83 | 38
[NAME] |  |  |  |  |  |  |  |  | 29 | 40 | 22 | 9 | 0 |  |  | 15.83 | 38
P16469 |  |  |  |  |  |  |  |  | 29 | 40 | 22 | 9 | 0 |  |  | 15.83 | 38
P16465 |  |  |  |  |  |  |  |  | 29 | 40 | 22 | 9 | 0 |  |  | 15.83 | 38
P15523 |  |  |  |  |  |  |  |  | 29 | 40 | 22 | 9 | 0 |  |  | 15.83 | 38
P16476 |  |  |  |  |  |  |  |  | 22 | 30 | 16 | 7 | 0 |  |  | 14.58 | 35
P16477 |  |  |  |  |  |  |  |  | 22 | 30 | 16 | 7 | 0 |  |  | 14.58 | 35
P16478 |  |  |  |  |  |  |  |  | 22 | 30 | 16 | 7 | 0 |  |  | 14.58 | 35
P16461 |  |  |  |  |  |  |  |  | 15 | 20 | 11 | 4 | 0 |  |  | 15.83 | 38
P16463 |  |  |  |  |  |  |  |  | 15 | 20 | 11 | 4 | 0 |  |  | 15.83 | 38
P16464 |  |  |  |  |  |  |  |  | 15 | 20 | 11 | 4 | 0 |  |  | 15.83 | 38
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Womens Outerwear
E29949 |  |  |  |  |  |  |  |  | 7 | 11 | 9 | 3 | 0 |  |  | 16.67 | 40
991212 |  |  |  |  |  |  |  |  | 7 | 11 | 9 | 3 | 0 |  |  | 16.67 | 40
991214 |  |  |  |  |  |  |  |  | 9 | 15 | 12 | 4 | 0 |  |  | 16.67 | 40
E29948 |  |  |  |  |  |  |  |  | 7 | 11 | 9 | 3 | 0 |  |  | 18.75 | 45
991194 |  |  |  |  |  |  |  |  | 9 | 15 | 12 | 4 | 0 |  |  | 18.75 | 45
991192 |  |  |  |  |  |  |  |  | 7 | 11 | 9 | 3 | 0 |  |  | 18.75 | 45
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Womens Knits
P16573 |  |  |  |  |  |  |  |  | 8 | 12 | 7 | 3 | 0 |  |  | 16.67 | 40
P16572 |  |  |  |  |  |  |  |  | 8 | 12 | 7 | 3 | 0 |  |  | 16.67 | 40
P16574 |  |  |  |  |  |  |  |  | 8 | 12 | 7 | 3 | 0 |  |  | 16.67 | 40
P17244 |  |  |  |  |  |  |  |  | 11 | 16 | 9 | 4 | 0 |  |  | 16.67 | 40
P17243 |  |  |  |  |  |  |  |  | 11 | 16 | 9 | 4 | 0 |  |  | 16.67 | 40
P17242 |  |  |  |  |  |  |  |  | 11 | 16 | 9 | 4 | 0 |  |  | 16.67 | 40
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Womens Bottoms
P16230 |  |  |  |  |  |  |  |  | 6 | 9 | 6 | 4 | 0 |  |  | 18.75 | 45
O33103 |  |  |  |  |  |  |  |  | 6 | 9 | 6 | 4 | 0 |  |  | 18.75 | 45
P17077 |  |  |  |  |  |  |  |  | 6 | 9 | 6 | 4 | 0 |  |  | 20.83 | 50
P15524 |  |  |  |  |  |  |  |  | 6 | 9 | 6 | 4 | 0 |  |  | 20.83 | 50
P17071 |  |  |  |  |  |  |  |  | 6 | 9 | 6 | 4 | 0 |  |  | 22.92 | 55
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  | WOMENS APPAREL TOTAL