+ Reply to Thread
Results 1 to 5 of 5

Route formula

  1. #1
    Registered User
    Join Date
    12-01-2009
    Location
    New England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Route formula

    Anyone know the formula for finding routes of exponents greater than 3?

    Actually, what I am trying to do is the following:

    I have three columns of numbers, lets say columns A and B and C.

    Column A contains a sequence of numbers. Column B contains all numbers the same, which are being used as an exponent.

    Column C contains a formula displaying the result of number in column A, with another (external) formula applied, then raised to the power of the number in column B.

    Number in column B (the exponent applied) is always greater than three.

    I need column D to display the column B route of C.

    In other words, if column B contains all 4's, Column C is displaying "N" to the fourth power (some number raised to the power of 4). I need column D to show what "N" is.

    If column B is 5, column C is showing "N" to the fifth power, and I still need to know what "N" is.

    Does that make sense?

    Is there a formula I can place in column D that will give me this?

    Thanks in advance.[/SIZE]
    Last edited by shg; 12-01-2009 at 11:43 PM.

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Route formula

    Does =C1^(1/B1) work?
    Option B would be to simply apply the additional formula in C to whatever is in A and not use the exponent.

  3. #3
    Registered User
    Join Date
    12-01-2009
    Location
    New England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Route formula

    It appears to work.

    Can you remind me what the "^" does?

    I do have a lot of years under my belt with Excel, but don't use it regularly anymore.

    Thanks.[/SIZE]
    Last edited by shg; 12-01-2009 at 11:44 PM.

  4. #4
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Route formula

    It raises a number to a given power. It's the symbol Excel uses for exponents.

  5. #5
    Registered User
    Join Date
    12-01-2009
    Location
    New England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Route formula

    Okay, right. So the (1/range) reverses it. I remember now.

    I've got a doozy coming in another thread. Maybe not as tough as I think though.

    Thanks a lot!

+ 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