+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Forum Contributor Saeber4777's Avatar
    Join Date
    06-06-2014
    Location
    United States
    MS-Off Ver
    365 Enterprise
    Posts
    159

    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, 2019
    Posts
    2,357

    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

  3. #3
    Forum Contributor Saeber4777's Avatar
    Join Date
    06-06-2014
    Location
    United States
    MS-Off Ver
    365 Enterprise
    Posts
    159

    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)

Similar Threads

  1. Replies: 5
    Last Post: 04-09-2014, 10:36 PM
  2. Formula to spill value to another cell after reaching a specific amount.
    By pjpankey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-27-2013, 06:03 PM
  3. [SOLVED] Deducting a specific amount of time from a number
    By Lizette in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-27-2012, 08:22 PM
  4. Replies: 1
    Last Post: 01-19-2012, 01:26 AM
  5. Replies: 5
    Last Post: 12-06-2010, 05:01 PM
  6. Replies: 5
    Last Post: 09-30-2010, 08:02 PM
  7. [SOLVED] would like to know the formula amount and display word
    By sarah in forum Excel General
    Replies: 1
    Last Post: 06-24-2005, 04:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1