+ Reply to Thread
Results 1 to 3 of 3

Increasing the exponent by one per cell

  1. #1
    Registered User
    Join Date
    09-23-2014
    Location
    Finland
    MS-Off Ver
    2013
    Posts
    2

    Increasing the exponent by one per cell

    Hi.

    A beginner question since I'm fairly new to excel but I'm trying to create a formula that would increase the exponent by one per cell but just can't figure it out. The cells would go like this:

    A1: a number
    A2: $A$1^1
    A3: $A$1^2
    A4: $A$1^3

    etc.

    Can this be achieved somehow?

    Thanks.

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Increasing the exponent by one per cell

    A2 =$A$1 ^(ROW() -1)

    like that?

  3. #3
    Registered User
    Join Date
    09-23-2014
    Location
    Finland
    MS-Off Ver
    2013
    Posts
    2

    Re: Increasing the exponent by one per cell

    Yes! Thank you so much.

+ 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. [SOLVED] Sine wave with increasing peaks and increasing troughs
    By JimDandy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-18-2013, 06:28 PM
  2. Increasing a cell reference
    By greiner524 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-30-2012, 08:53 AM
  3. Excel 2007 : Increasing the value of cell and comparison
    By qsebastian in forum Excel General
    Replies: 6
    Last Post: 03-10-2010, 05:09 PM
  4. logging a xml feed-copy the same cell and paste into increasing cell positions.
    By sanpedro_nz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2009, 12:10 AM
  5. increasing and decreasing a value in a cell
    By cwal in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-14-2006, 01:55 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