=IF(ISERROR(cellref),erroraction,noerroraction)
=IF(ISNUMBER(cellref),noerroraction,erroraction)

You can also use it in range functions, such as
=SUM(IF(ISNUMBER(range),range))
but you must array enter (Ctrl-Shift-Enter)

Jerry

DLZ217 wrote:

Is it possible to ignore a cell in a formula if the data is #DIV/0 ive tried
messing around with IF statements but I cant seem to figure it out