You can use ISERROR Function

=IF(ISERROR(your formula here,0,your formula here)

If you have a lot of such functions it can slow calculation times. In which case you can use Con ditional Formatting to hide the error, see

http://www.excel-it.com/excel_condit...formatting.htm