am clueless :(What formulas do i use to calculate an increasing percentage in excel?
Assume Year 1 3390 is in cell A1 - Year 2 is to be in B1 put formula in B1 as follows = A1*1.07
Then drag this into cells C1 - D1 for years 3 %26amp; 4
If you wish whole numbers only use formula in B1 as follows =Round(A1*1.07,0) then drag this across
If you wish to use cells other than B1- D1 use copy paste from Year 1 cell
Hope this helpsWhat formulas do i use to calculate an increasing percentage in excel?
3390
=a1 * 1.07
=a2 * 1.07
=a3 * 1.07
No comments:
Post a Comment