Dear All good evening,
i have a query in excel sheet, i have an amount in a column and we want the calculate amt in next col like as...
We want add 5 % in amt in every year.
<TBODY>
</TBODY><COLGROUP><COL span=2><COL></COLGROUP>
i have a query in excel sheet, i have an amount in a column and we want the calculate amt in next col like as...
We want add 5 % in amt in every year.
Amt</SPAN> | Year </SPAN> | Reqd Amt</SPAN> |
10000</SPAN> | 5</SPAN> | 55000</SPAN> |
15000</SPAN> | 4</SPAN> | 64500</SPAN> |
20000</SPAN> | 3</SPAN> | 63000</SPAN> |
10000</SPAN> | 2</SPAN> | 20500</SPAN> |
Example-1 1st Year</SPAN> | 10000</SPAN> | B7</SPAN> |
2nd Year</SPAN> | 10500</SPAN> | B7+B7*5%</SPAN> |
3rd Year</SPAN> | 11000</SPAN> | B8+B7*5%</SPAN> |
4th Year</SPAN> | 11500</SPAN> | B9+B7*5%</SPAN> |
5th Year</SPAN> | 12000</SPAN> | B10+B7*5%</SPAN> |
Total</SPAN> | 55000</SPAN> | SUM(C7:C11)</SPAN> |
Example-2 | ||
1st Year</SPAN> | 15000</SPAN> | B14</SPAN> |
2nd Year</SPAN> | 15750</SPAN> | B14+B14*5%</SPAN> |
3rd Year</SPAN> | 16500</SPAN> | B15+B14*5%</SPAN> |
4th Year</SPAN> | 17250</SPAN> | B16+B14*5%</SPAN> |
Total</SPAN> | 64500</SPAN> | SUM(C14:C17) </SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=2><COL></COLGROUP>