+ Reply to Thread
Results 1 to 3 of 3

Formula to display an amount in a specific cell after a certain time

  1. #1
    Registered User
    Join Date
    06-06-2014
    Posts
    93

    Formula to display an amount in a specific cell after a certain time

    I have worked on a formula for this for hours and cannot move past the complexity of the variables given my knowledge of excel.

    I have provided the link to the workbook (tab 1010).

    I have an investment amount in U column.

    Depending on the amount invested, the time the funds are locked up change.

    I am wanting the funds to appear in column V when they unlock.
    Column B has the time (in days).



    Please read the blue table inside the worksheet. I provided clearer instructions there.

    https://drive.google.com/file/d/1qy-...ew?usp=sharing

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016
    Posts
    1,858

    Re: Formula to display an amount in a specific cell after a certain time

    v38=SUMPRODUCT(($B38=LOOKUP($Q$8:$Q$19,$T$9:$U$12)+$P$8:$P$19)*$Q$8:$Q$19) and pull down
    In order to ask a question you must already know most of the answer. Ask A Foolish Question, Robert Sheckley

  3. #3
    Registered User
    Join Date
    06-06-2014
    Posts
    93

    Re: Formula to display an amount in a specific cell after a certain time

    Tim, you rock brother. Thank you. I'm familiar with each of those formula types, but have no idea how they work together like that. I didn't realize you could stack those to perform a task like this.
    Last edited by Saeber4777; 01-04-2018 at 05:50 PM.

+ 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