Can you please provide EXCEL formulas for the calculations as mentioned in picture1 using information from picture2. A picture3 shows the cells that they are referring to in picture1. I just need the EXCEL formula. Thank you in advance.

Type the formulas to calculate the following: In cell B9, calculate the grand total amount owing for all customers. In cell B10, calculate the total cost amount of all the mussels and crabs sold. In cell B11, calculate the amount of profit or loss made from these sales. In cell A11, replace the label with a calculation to determine whether or not the amount in cell B11 is a Profit from Sales or a Loss from Sales as the label (assume that would be considered a Profit rather than a Loss) > Adjust the row heights to show the whole label for A11:A14. Tip: use a similar alternative method to adjusting the column-width. In cell B12, calculate how many customers your grandfather has. In cell B13, calculate how many customers bought crabs. In cell B14, calculate the total sale amount for all the customers who bought 10 or more kilograms of mussels. > In cell B15, calculate the average number of whole kilograms of seafood sold mussels and crabs. E K B D F G H J 1 Cost Retail 2 Mussels R12,40 R21,70 3 Crabs R25,60 R44,80 4 Markup% 75,0% 5 Discount% 8,5% EFT 6 VAT % 15,0% 7 8 Retailer Name Phone # Qty Mussels Qty Crabs Pay Type Amt@Retail Discounted Amt VAT Amt Total Due 9 Sumfing Fishy Tom +27 82 123 4567 10 0 EFT R217,00 R198,56 R29,78 R230,00 10 Seafood Snacks Harry +27 61 123 4569 0 13 EFT R582.40 R532,90 R79,93 R610,00 11 Salt Fresh Dick +27 83 123 4568 14 24 Account R1 379,00 R1 379,00 R206,85 R1 590,00 12 R0,00 R0,00 R0,00 R0,00 13 R0,00 R0.00 R0,00 R0.00 14 R0,00 R0,00 R0,00 R0,00 15 16 17 18 8 9 Total Sales 10 Cost of Sales 11 Profit or Loss No of 12 Customers No of Crab 13 Customers Sales of Mussel 14 Customers 15 Avg kilograms 16 17 18 19 20 8 CO 4 Type the formulas to calculate the following: In cell B9, calculate the grand total amount owing for all customers. In cell B10, calculate the total cost amount of all the mussels and crabs sold. In cell B11, calculate the amount of profit or loss made from these sales. In cell A11, replace the label with a calculation to determine whether or not the amount in cell B11 is a Profit from Sales or a Loss from Sales as the label (assume that would be considered a Profit rather than a Loss) > Adjust the row heights to show the whole label for A11:A14. Tip: use a similar alternative method to adjusting the column-width. In cell B12, calculate how many customers your grandfather has. In cell B13, calculate how many customers bought crabs. In cell B14, calculate the total sale amount for all the customers who bought 10 or more kilograms of mussels. > In cell B15, calculate the average number of whole kilograms of seafood sold mussels and crabs. E K B D F G H J 1 Cost Retail 2 Mussels R12,40 R21,70 3 Crabs R25,60 R44,80 4 Markup% 75,0% 5 Discount% 8,5% EFT 6 VAT % 15,0% 7 8 Retailer Name Phone # Qty Mussels Qty Crabs Pay Type Amt@Retail Discounted Amt VAT Amt Total Due 9 Sumfing Fishy Tom +27 82 123 4567 10 0 EFT R217,00 R198,56 R29,78 R230,00 10 Seafood Snacks Harry +27 61 123 4569 0 13 EFT R582.40 R532,90 R79,93 R610,00 11 Salt Fresh Dick +27 83 123 4568 14 24 Account R1 379,00 R1 379,00 R206,85 R1 590,00 12 R0,00 R0,00 R0,00 R0,00 13 R0,00 R0.00 R0,00 R0.00 14 R0,00 R0,00 R0,00 R0,00 15 16 17 18 8 9 Total Sales 10 Cost of Sales 11 Profit or Loss No of 12 Customers No of Crab 13 Customers Sales of Mussel 14 Customers 15 Avg kilograms 16 17 18 19 20 8 CO 4