Hi!
So what I am needing to make is a general spreadsheet that people can use to just plug in cash flows and dates and have the spreadsheet return a present value, basically just a fill in the blank type of sheet. The people using it would most likely have little experience with Excel formulas and so would not know how to modify the formula to get the number they need. My problem is that the XNPV function reads blank cells as zero values and so then I get a number error when there are blank cells. I'm still new to how this forum works, but I think I attached what I have so far correctly. Any help would be greatly appreciated!
Bookmarks