Hi, can you please help me find the excel formula that can calculate the following?

The Quote Price (amount that will be invoiced) is calculated by multiplying total cost by 150%. Customers are often given a discount on the Materials, there are two discount codes D1 and D2 and each attract a different discount depending on the style of kitchen. The Discounts table on the Costs sheet shows the discount rate for each combination. In H72 calculate the Quote Price. Adjust the calculation to check H71, if it is empty do not apply a discount, if it contains a D1 look up the appropriate discount, apply it to the cost of Materials and subtract it from the calculated Quote Price. Refine the calculation in H2, so if the discount code is changed to D2, it applies the appropriate discount. TOTAL LABOUR $4,342.94 PRODUCTION OVERHEADS \begin{tabular}{lrc} Cost & Days & 4 \\ \hline TOTAL OVERHEADS & $,439.85 \\ \hline \hline \end{tabular} SUMMARY TOTAL COST $1,595.49 Discount Code: Quote Price: The Quote Price (amount that will be invoiced) is calculated by multiplying total cost by 150%. Customers are often given a discount on the Materials, there are two discount codes D1 and D2 and each attract a different discount depending on the style of kitchen. The Discounts table on the Costs sheet shows the discount rate for each combination. In H72 calculate the Quote Price. Adjust the calculation to check H71, if it is empty do not apply a discount, if it contains a D1 look up the appropriate discount, apply it to the cost of Materials and subtract it from the calculated Quote Price. Refine the calculation in H2, so if the discount code is changed to D2, it applies the appropriate discount. TOTAL LABOUR $4,342.94 PRODUCTION OVERHEADS \begin{tabular}{lrc} Cost & Days & 4 \\ \hline TOTAL OVERHEADS & $,439.85 \\ \hline \hline \end{tabular} SUMMARY TOTAL COST $1,595.49 Discount Code: Quote Price