I just noticed you're running Excel 2007 in which case you can in fact use:
=IFERROR(A1/B1,"")
Change the Null ("") to be whatever you want returned if the preceding calculation results in an error.
NOTE: this function is not backwards compatible so if you ever need to run the spreadsheet on an earlier version you should use the approach mentioned in the first post.
Bookmarks