To explain the steps clearly, we'll use a simple dataset to calculate taxes on an individual item. We have formatted cells C4, C6, and C7 as Accounting data. Also, we have applied…
Step 1 - Arranging Proper Dataset We have the Products in Column B and the Price Without GST in Column C. We have to create three important columns. In Column D we…