LinkBack URL
About LinkBacks
One of the values in row 80 is #N/A. There is nothing wrong with the formula that you are using, so the error must be in the values being evaluated.
One of the values in row 80 is #N/A. There is nothing wrong with the formula that you are using, so the error must be in the values being evaluated.
Bernie Deitrick
Excel MVP 2000-2010
That was it, Bernie. Thanks for letting me know that. I didn't know that you couldn't have #N/A's in order for this to work. There was a rogue formula, and this solved it. Thanks!
You can have errors in your data - you just need to anticipate that condition.
You could change
Assumptions!$I$73:$CK$80
to
IFERROR(Assumptions!$I$73:$CK$80,0)
and enter the formula using Ctrl-Shift-Enter rather than just enter.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks