+ Reply to Thread
Results 1 to 14 of 14

Multiplying and adding a sequence

Hybrid View

  1. 03-26-2014, 07:35 PM #1
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Multiplying and adding a sequence

    In B2 and copy down,

    =A2*(1+B3)

    A
    B
    1
    x
    2
    0.95098
    10.38467
    3
    0.94845
    9.91997
    4
    0.94565
    9.45914
    5
    0.94253
    9.00279
    6
    0.93902
    8.55173
    7
    0.93506
    8.10708
    8
    0.93056
    7.67012
    9
    0.92537
    7.24248
    10
    0.91935
    6.82657
    11
    0.91228
    6.42543
    12
    0.90385
    6.04327
    13
    0.89761
    5.68614
    14
    0.89185
    5.33476
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  2. 03-26-2014, 07:57 PM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Multiplying and adding a sequence

    Quote Originally Posted by shg View Post
    In B2 and copy down,

    =A2*(1+B3)
    Nice one!

    I'm not having much success getting it all in a single formula.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Creating a sequence based on numbers in one column and adding "01,02..." to a new sequence
    By JCR1968 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2013, 08:06 AM
  2. Adding Numbers the multiplying
    By Soltisolti in forum Excel General
    Replies: 3
    Last Post: 08-24-2010, 01:56 AM
  3. Multiplying and adding in the same spreadsheet
    By Baydestrian in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-04-2007, 09:32 AM
  4. Adding and Multiplying Question
    By John Bordieri in forum Excel General
    Replies: 1
    Last Post: 05-25-2005, 08:11 PM
  5. Adding and Multiplying between worksheets
    By BJH in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-24-2005, 11:56 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1