Find Subtotal, GST, PST and Total using EXCEL FUNCTION PLEASE. Thank you!

Table 1. Order Table Table 2: Product Information Colour Size Orderid Ordere chem Quant Unit Price Subtotal GST (6) PST (Pre-Tax) Total After Category Price 1001 Hoody T Shit $ s 25 00 15.00 1042 1000 1941 wo TO 1025 1000 1007 Table 3: Order Summary 4 13 11 12 11 14 15 Category Number of items ordered Total Price (After Tax 1010 1011 . 1012 1013 w M 3 XXL S S XXL M XX M a na 3 L s M M 3 S 3 navy burtshirts burnt red 1-shirts Total t-shirts HOY bum HOGY navy blue bumtred bum bune T- may be Hoody bum may be navy blue T-shirt may be TANE navy blue TASNA bume burnt F rawy baie Tshirt humi Hoody at navy blue Hoody navy blue navy blue hogy navy blin T-Shirt navy blue T- may be Hoody navy blue T-shirt navy blue T shirt nowy blue TE 1 $ 25.00 1 S 25.00 2 $ 25.00 1 $ 15.00 2 51100 4 1 $150 1 SES OO 1 $15.00 2 $ 2500 2 $15.00 15.00 S 1000 an 1500 $ 1 $ 15.00 1 $15.00 S 25.00 3 S2000 2 2 S 25.00 3 S 2600 2 $ 2500 S 1600 1 3 S 25.00 2 $ 16.00 1 15 15.00 18 19 navy blue bades! cum reledes Total hoodes Table 4: XXL Into 21 22 23 34 25 26 HOODY 1017 1018 1019 1020 1021 1022 1023 1024 102 Category Number of items ordered Total Price (After Tax Tocal XXL this Tocar XL hoodies 20 XXL M