Formula to handle Blank Cells

**coreytroy** · 08-10-2014, 07:45 PM

Please Login or Register  to view this content.

If the range above are all empty I get a #DIV/0 error.

What is the best way to handle this via formula?

**FDibbins** · 08-10-2014, 07:48 PM

Try this...
=IFERROR(FORECAST($D$16,$B$4:$B$11,K4:K11),"")

**Ron Coderre** · 08-10-2014, 07:48 PM

Since you are using Excel 2007

Please Login or Register  to view this content.

OR
Replace the second IFERROR argument with whatever you want...like:

Please Login or Register  to view this content.

Does that help?

**rcm** · 08-10-2014, 07:48 PM

Please Login or Register  to view this content.

**coreytroy** · 08-10-2014, 08:01 PM

Thanks for the reply guys, appreciated.
Ended up using:

Please Login or Register  to view this content.

Used the "" to eliminate the invalid Date.

**FDibbins** · 08-10-2014, 08:08 PM

Glad we could help, and thanks for the feedback

Re: Formula to handle Blank Cells