Exceldummy2018
New Member
- Joined
- Apr 30, 2018
- Messages
- 2
I would like to create a template that could automatically compute the values below each time i change the value in in the yellow field
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I need a template where it can auto calculate A3-A7 and D3-D7 when i input the Sales Price value
Sales Price | 10,000,000 | |||
AMOUNT | RATE | INTEREST PAYABLE | ||
First RM500K | A3 | 1.00% | D3 | |
NextRM500K | A4 | 0.80% | D4 | |
Next RM2M | A5 | 0.70% | D5 | |
Next RM2M | A6 | 0.60% | D6 | |
Thereafter | A7 | 0.50% | D7 | |
From manual calculation, | ||||
A3 | 500,000 | D3 | 5000 | |
A4 | 500,000 | D4 | 4000 | |
A5 | 2,000,000 | D5 | 14000 | |
A6 | 2,000,000 | D6 | 12000 | |
A7 | 5,000,000 | D7 | 25000 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I need a template where it can auto calculate A3-A7 and D3-D7 when i input the Sales Price value