Screen-11-2-2021_83055_PM.png
Hello, i want to know if there is a possability to fix this problem? if you look at the picture i want to divide the CF by the discount factor. But since its a dynamic array it only continues to divide d13 by d14, instead of continuing to divide E13 by E14 etc. Ofcourse 40/1,06 is not the same as 40/1,03, so i want to know if there is a formula to use inside of the sequence formula to make it divide the next cells in line?
Kind regard Jon
Bookmarks