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.
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.
Bernie Deitrick
Excel MVP 2000-2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks