R
RayYeung
I am preparing an Excel template for my users to help them calculat
compound interest rate over several years based on the interest rate o
a bank.
The first sheet contains 3 columns, StartDate, EndDate, Rate.
The second sheet which will be hidden to the users is for all th
various calculations. There will always be a row for the amount at yea
end.
I would like to produce a summary in the third sheet with the interes
and the total amount at end of each year and at the end of the period
I know I can use pivot table but since it is an Excel template,
cannot pre-define the criteria. Is there a way to achieve that withou
using VBA
compound interest rate over several years based on the interest rate o
a bank.
The first sheet contains 3 columns, StartDate, EndDate, Rate.
The second sheet which will be hidden to the users is for all th
various calculations. There will always be a row for the amount at yea
end.
I would like to produce a summary in the third sheet with the interes
and the total amount at end of each year and at the end of the period
I know I can use pivot table but since it is an Excel template,
cannot pre-define the criteria. Is there a way to achieve that withou
using VBA