I have successfully hidden some error formulas (actually substituted a "-", not hid) but there is one formula that is stumping me.

It's a pretty involved spreadsheet, but here is the formula in question:

=IF(C2<P2,Q2-C2-D2,""), where column C = ONHAND, D = ONORDER, P = 8 WEEK MIN, and Q = 12 WEEK MAX.

This formula calculates my NEED of a product, by saying =IF(ONHAND is less than 8 WEEK MIN, take 12 WEEK MAX and subtract ONHAND and ONORDER).

This formula works great as long as I have quantities in my 8 WEEK MIN and 12 WEEK MAX column, but in some cases I have a new item that doesn't have any history or an old item that has very little sales volumne, so the 8 WEEK MIN and 12 WEEK MAX columns calculate to "-". Is there a way to hide the #VALUE! so my filter on this column will work properly?

Thanks,