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

1. ## 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.

2. ## 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. ## 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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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