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

[mike4777]

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-IeFSA8p_JjF_OLnJbZRDzZ-tFIzXD/view?usp=sharing

 

[StephenCrump]

Reposted: https://www.mrexcel.com/forum/excel...ll-column-after-certain-time.html#post4982199