I was wondering if i could get some help with formulas and how to apply them.

The instructions are below however i need a formula that will change when cell with X-800 in it changes to ZF300 on the CVP Analysis

Cost Volume Profit Analysis Product Name X-800 Variable Costs per Unit Break-Even Analysis Unit Sales Price Vary with Unit Costs Contribution Margin Per Unit Unit Sales Direct Labor Break Even Volume in Units Total Fixed Costs Direct Material Break Even Sales Value Factory Overhead 120.00 Other Vary-with-Unit Costs 80.00 Break Even Variable Costs Total Vary with Unit Costs 200.00 Direct Labor Direct Material Vary-with-Revenue Costs Factory Overhead Sales Commissions 5.0% Other Vary-with-Unit Costs Other Vary-with-Revenue Costs 1.5% Sales Commissions Total Vary with Revenue Costs Other Vary-with-Revenue Costs Total Variable Costs 'S Income Tax State Tax 10.0% Contribution Margin Federal Tax 5.0% Profit Before TaxFixed Costs and Pricing for the Year X-BOO ZF300 Fixed Cost Items Rent S 61,000.00 56,000.00 Utilities 5 13,400.00 5 14,600.00 Admin Costs S 26,200.00 26,000.00 ADUPInSUI 5 12,300.00 S 12,500.00 Unit Sales Price 5,600.00 5,800.00 Total Units Sold 350 370D1 In B4 use a formula to retrieve the Unit Sales Price from the Fixed Costs sheet for the 2 0 product shown in B3. D2 In B5 use a formula to retrieve the Unit Sale from the Fixed Costs sheet for the 2 O product shown in B3. D3 In B6 use a formula to retrieve the Total Fixed Costs from the Fixed Costs sheet for 2 the product shown in B3. D4 In ES use the information in the Labour Costs sheet to calculate the Direct Labour 2 Cost per unit for the product shown in B3. D5 In E6 use the information in the BoM to calculate the Direct Material Cost per unit 2 0 for the product specified in B3. D6 In E14 calculate the Variable Selling & Admin Cost per unit (as a %). D7 In H4 calculate the Contribution Margin per Unit (this is the Unit Sales Price less the 2 Variable Manufacturing Cost per unit and the Variable Selling & Admin Cost per unit). D8 In H5 calculate your break-even volume (in units). Apply an appropriate rounding 2 function to get the answer to 0 decimal places (Consider whether to use ROUND, ROUNDUP or ROUNDDOWN). (This answer is very important so double check it!) D9 In H6 calculate the Break-Even Sales Value ($ sales or break even volume in units). D10 In H9 to H14 calculate the Break-Even Variable Costs using the calculated figures in H5 or H6 (where appropriate). Note, each answer is worth 2 mark which will only be awarded if the answer and formula are correct. D11 In H17 calculate the Break-Even Contribution Margin. 1 D12 In H18 calculate the Break-Even Profit Before Tax. (If we hadn't rounded Break Even Units this should be 0)