Any idea why the following formula would ref out?
=IF(B3024>today,E3024,E3024*(1-0.94)*0.94^(today-B3024))
In this formula, "today" is not for today's date, but rather to change to look at calc's on historical dates. Column B is the date column, and Column E is the return value column.
Sorry if I'm missing something really obvious. Thanks for your help!
Michael
Bookmarks