Wednesday, February 15, 2012

What formulas do i use to calculate an increasing percentage in excel?

for example the first number is 3390 i have to make a formula which shows the next 3 years increasing by 7% every year...



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
  • ashton kutcher cheating
  • art games
  • No comments:

    Post a Comment