Computer problems,Computer help
*AX SOFT>>>Programming & Design

What is the Excel formula for this?


I need to start in cell B1 with any given number, lets say 100 to make it simple. Then I need a formula to calculate the 3% of the original number and add it. In this case it would be 103 (to show in B2), then in the next cell I need the 3% of 103 which is 3.09 and add it so it is 106.09 (to show in B3). And so on. I need to do it with 1%, 2%, 3%, 5% and 10%. Preferably in column B, so I can write notes in column A. Thanks.

B1: =(100*1.03)
B2: =(B1*1.03)
B3: =(B2*1.03)

etc,

B1: <The data>
B2: =(B1 * 1.03)
B3: =(B2 * 1.03)


Etc, etc...

Tags
  General - Computers & Internet   Software   Security   Programming & Design   Facebook   Flickr   Google   MSN   MySpace
Related information
  • Table formatting?

    Use <PRE> with tables initially aligned in Courier New font. <PRE> Table </PRE>

    ...
  • Which programming software is the best?

    If you're using Matlab, you might want to try the Python programming language with the NumPy/SciPy extensions - I'm told they're quite similar. Have a look at this: ...

  • Write a Java program that calculates the value of PI and then computes and displays the area of a circle with?

    If you're stuck, then paste the code that you've written so far, so that we can look at it and make suggestions.

    ...
  • Does anyone know what font they are using in this logo?

    It's ITC Studio Script, see ...

  • How do you post links on here?

    If you just type the URL, the website will create the hyperlink for you (a link that can be clicked to go to the website). So for instance, just type "http://www.yahoo.com" and you will g...

  • Does anyone know where I can make my own CSS codes online for free?

    If you are going to do CSS (plain text file with a css extension), then you should go ahead an d get an HTML Editor that will do CSS, HTML, PHP, etc. Matrix Y2K: ...

  • I am creating a menu using <ul> in php?

    you started with LI not UL

    ...
  • How can i know that if i got a good technical service on my web page???

    NEVER get your web hosting from the same people that you paid to build your website. This is putting all your eggs in one basket, and gives you no leverage should you ever have a problem. Ideally, ...

  •  

    Categories--Copyright/IP Policy--Contact Webmaster