Results 1 to 3 of 3

Thread: Creating a Compound Table for a Variable Term
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular tsroque's Avatar
    Join Date
    Jan 2007
    Posts
    123
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Creating a Compound Table for a Variable Term

    Hi!

    This is NOT an compound interest question. I need to create a compound formula or table to reach a desired answer.

    EXAMPLE:
    So if I need to decrease 50 by 20%, 3 times (variable)
    ------------------------
    1) 50 x .8 = 40
    2) 40 x .8 = 32
    3) 32 x .8 = 25.6
    ------------------------
    Answer: 25.6

    What is given is 50 (B4), 0.8 (B8) and 3 (B9)
    B9 is my variable. It could change to ANY number, but I need the formula to ONLY calculate THAT many times.

    What is the best way to do this?

  2. #2
    Board Regular
    Join Date
    Jul 2014
    Location
    Memphis, TN
    Posts
    2,680
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Creating a Compound Table for a Variable Term

    50*(0.8^3)
    Code:
    =B4*(B8^b9)
    Excel 2013, 2016 with PowerBI
    Knowing that it can be done is half the battle!

  3. #3
    Board Regular tsroque's Avatar
    Join Date
    Jan 2007
    Posts
    123
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creating a Compound Table for a Variable Term

    That does it! Thank you!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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