A1 = 14829
A2 = '=(a1)*1.03'
copy formula to A2 - A20
A21 = '=SUM(A1:A20)'

HTH
--
Jock Waddington


"Ahmed" wrote:

I want to calculate the total salary amount for 20 years, but for each year
the employee has merit increase by 3%

For Example:
The Actual Salary = 14829
After 20 years the actual salary = 26,782.82
The Total salary amount after 20 years = 410,414.60


thanks