I need a dynamic way to calculate the net present value of lot contracts instead of having to manually click and drag the referenced cells. In the attachment, values and dates calculate/fill if they meet certain criteria, if not, they're left blank "".
I found an older post that uses the offset function, but I don't know how to apply it to my model. It won't let me post the link because I'm new, but I can direct you.
Thank you!
Bookmarks