+ Reply to Thread
Results 1 to 2 of 2

Increment number by itself formula?

  1. #1
    Registered User
    Join Date
    08-21-2008
    Location
    Nebraska
    Posts
    1

    Increment number by itself formula?

    I am looking for a way to make a number equal itself plus another number a set amount of times.
    In programming language, you assign value to X and Y then set a parameter (Z) for the amount of times to run a X=X+Y loop and you are done, but I am lost on how to create this formula in Excel.
    Cell A1= Number of Times X will be added to itself or Z
    Cell B1= The Starting amount for X
    Cell C1= Y: The amount added to X every loop
    Cell D1 = Total
    Can this be done?
    Excel version is 2003.

    Thank you for any help that can be provided.
    -Zumsing from NE

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    In D1: =B1 + A1 * C1

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Print Formula
    By swordswinger710 in forum Excel Programming / VBA / Macros
    Replies: 36
    Last Post: 06-27-2008, 04:30 AM
  2. Replies: 1
    Last Post: 05-06-2008, 04:31 PM
  3. Insert a formula with relative cell reference based on a number in a column
    By Dcritelli in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-16-2007, 05:54 PM
  4. setting number to one decimal place with formula
    By caliskier in forum Excel General
    Replies: 1
    Last Post: 01-17-2007, 06:54 PM
  5. Macro to change month's number in a formula
    By nejmeh in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-12-2007, 04:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1