I have ssumed that you have a formula that either gives a value or #N/A

To do what you want you need to refer to the error, not the result

=IF(ISERROR(cell ref),0,1)

If the cell you are pointing to results in an error (eg #N/A) then it
will give a value of 0, if no error found then it will give a value of
1

Hope this helps

Steve