Sorry, I'm unable to upload files. However, it should be easy to create your own file from the example I posted. Just select the table from my post, copy it, then paste it into a blank workbook. Make sure that you delete any extra rows or columns (Commission should be in the A1 cell). Or you can manually type in the headings in columns A, D, I, and cell G1, there aren't that many. Then enter the formulas from the formula table in the indicated cells.
This actually might be a good time to mention that using Named Ranges can make your formulas easier to read. If I used Named Ranges for B1:B5, then the formulas look like:
<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">Commission</td><td style="text-align: right;;">10%</td><td style="text-align: right;;"></td><td style=";">Amount</td><td style="text-align: right;;">100</td><td style="text-align: right;;"></td><td style=";">Grand Total</td><td style=";">Amount</td><td style="text-align: right;;">100</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">Fee</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style=";">Commission</td><td style="text-align: right;;">10</td><td style="text-align: right;;"></td><td style="text-align: right;;">120.20</td><td style=";">Commission</td><td style="text-align: right;;">10</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">Delivery</td><td style="text-align: right;;">6</td><td style="text-align: right;;"></td><td style=";">Fee</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Fee</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">Tax I Flat</td><td style="text-align: right;;">1.5</td><td style="text-align: right;;"></td><td style=";">Delivery</td><td style="text-align: right;;">6</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Delivery</td><td style="text-align: right;;">6</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">Tax II %</td><td style="text-align: right;;">10%</td><td style="text-align: right;;"></td><td style=";">Tax I Flat</td><td style="text-align: right;;">1.50</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Tax I Flat</td><td style="text-align: right;;">1.50</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Tax II</td><td style="text-align: right;;">1.70</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Tax II</td><td style="text-align: right;;">1.70</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Grand Total</td><td style="text-align: right;;">120.20</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Grand Total</td><td style="text-align: right;;">120.2</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet3</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E2</th><td style="text-align:left">=E1*Commission</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E3</th><td style="text-align:left">=Fee</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E4</th><td style="text-align:left">=Delivery</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E5</th><td style="text-align:left">=TaxI</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E6</th><td style="text-align:left">=SUM(<font color="Blue">E2:E4</font>)*TaxII</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">I1</th><td style="text-align:left">=(<font color="Blue">G2-Fee-Delivery-TaxI-(<font color="Red">Fee+Delivery</font>)*TaxII</font>)/(<font color="Blue">1+Commission+Commission*TaxII</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">I2</th><td style="text-align:left">=I1*Commission</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">I3</th><td style="text-align:left">=Fee</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">I4</th><td style="text-align:left">=Delivery</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">I5</th><td style="text-align:left">=TaxI</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">I6</th><td style="text-align:left">=SUM(<font color="Blue">I2:I4</font>)*TaxII</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E8</th><td style="text-align:left">=SUM(<font color="Blue">E1:E6</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">I8</th><td style="text-align:left">=SUM(<font color="Blue">I1:I6</font>)</td></tr></tbody></table></td></tr></table><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Workbook Defined Names</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Name</th><th style="text-align:left">Refers To</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">Commission</th><td style="text-align:left">=Sheet3!$B$1</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">Delivery</th><td style="text-align:left">=Sheet3!$B$3</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">Fee</th><td style="text-align:left">=Sheet3!$B$2</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">TaxI</th><td style="text-align:left">=Sheet3!$B$4</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">TaxII</th><td style="text-align:left">=Sheet3!$B$5</td></tr></tbody></table></td></tr></table><br />
Here's an explanation of how to create Named Ranges:
https://support.office.com/en-us/ar...formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64