(a2)/(1-6.8%) is the amount you had a year ago
and (a2)/(1-6.8%)-a2 is the amount of interest you received last year.
This assumes no monthly compounding and is probably not the right way to do the calculation.
Title | # Comments | Views | Activity |
---|---|---|---|
How to replace : with / in excel column | 4 | 48 | |
VLOOKUP to a Closed Workbook | 22 | 61 | |
Merging multiple rows to one | 22 | 32 | |
Excel: formula to determine # to meet goal | 5 | 10 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!