Data 1 is the details of items brought from shops A and B.
Data 2 is a menu of items in Shop B which is a long menu.
I want a formula to tell me if the items which we brought from Shop B in Data 1 is charged by more than 5% than the menu (estiamated) amount given in Data 2
Output expected as below :
If overcharged then : amount by how much it is overcharged.
If not overcharged then : "Not overcharged".
In layman way, I would manually calculate it like this: (492+512)-((318+327)*105%). The return value in this case is 326.75.
Please let me know if any additional information is needed. Highly obliged to this website.
Data 1 : Items we brought
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Data 2 : An estimate given by Shop B
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Data 2 is a menu of items in Shop B which is a long menu.
I want a formula to tell me if the items which we brought from Shop B in Data 1 is charged by more than 5% than the menu (estiamated) amount given in Data 2
Output expected as below :
If overcharged then : amount by how much it is overcharged.
If not overcharged then : "Not overcharged".
In layman way, I would manually calculate it like this: (492+512)-((318+327)*105%). The return value in this case is 326.75.
Please let me know if any additional information is needed. Highly obliged to this website.
Data 1 : Items we brought
Items | Price | Shop |
chair | 490 | Shop A |
table | 492 | Shop B |
scissor | 487 | Shop A |
calculator | 512 | Shop B |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Data 2 : An estimate given by Shop B
chair | 399 |
table | 318 |
scissor | 409 |
calculator | 327 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>