I wanted to use the easiest formula for to calculate the total amount in the following excel sheet. The conditions required for the calculation is in the another table below. Please help me to find the easiest formula.
Thanks in advance.
<tbody>
</tbody>
Conditons:
<tbody>
</tbody>
Thanks in advance.
ID | Customer Name | Customer Type | Previous Reading | Current Reading | Unit Consumed | Total Amount |
1 | Angelina | Domestic | 1258 | 1320 | 62 | |
2 | Boyd | Domestic | 1485 | 1698 | 213 | |
3 | Steven | Agriculture | 1103 | 1170 | 67 | |
4 | Joe | Industry | 2566 | 2891 | 325 | |
5 | John | Agriculture | 1654 | 1841 | 187 |
<tbody>
</tbody>
Conditons:
Customer Type | Minimum Charge Upto 20 units | For Consumed Unit between 21-250, additional cost per unit | For Consumed Unit above 250, additional cost per unit |
Domestic | $ 80.00 | $ 7.30 | $ 11.25 |
Industry | $ 200.00 | $ 10.15 | $ 15.5 |
Agriculture | $ 50.00 | $ 5.40 | $ 7 |
<tbody>
</tbody>