+ Reply to Thread
Results 1 to 4 of 4

Multiply a number with increasing value

Hybrid View

  1. #1
    Registered User
    Join Date
    04-07-2006
    Posts
    14

    Multiply a number with increasing value

    Lets say we have a list of numbers in one column

    ie:

    32,500
    32,500
    32,500
    32,500
    32,500
    32,500
    32,500
    32,500
    32,500
    32,500

    And we want:

    32,500
    65,000
    97,500
    130,000
    162,500
    195000
    227500
    260000
    292500
    325000
    Is there an easier way to do this then 32500*1, 32500*2, etc?

    Thanks.
    Last edited by SMAlvarez; 02-14-2011 at 08:57 PM.

  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

    re: Multiply a number with increasing value

    If the number values start in A2, then in B2 and copy down

    =A2*ROWS(B$2:B2)
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Multiply a number with increasing value

    Or, if the numbers start in A2
    In A3 place this and drag down:

    =A2+A$2

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Multiply a number with increasing value

    @Cutter,

    A reason NOT to do it that way is that if the number has decimals, repeated adding will accrue increasing amounts of error.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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