Good morning MelbTim

The standard way of trapping errors using formulae is using the ISERR()
function (which doesn't work with the #N/A error) and the ISERROR()
function. In general if you have a formula A1/B1 that is causing the
error then this formula in it's place would return 0:

=IF(ISERROR(A1/B1),0,A1/B1)

Really, you need to include details of what's causing the error - for
example if it's a lookup formula, it may be easier to solve.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=375130