Excel - Using ISERROR to replace #NUM, #VALUE, #N/A, #DIV/0!
If you dont want errors to display then you can wrap your function in an IF and ISERROR combination.
Code:
=IF(ISERROR(yourfunction),"0",yourfunction)
You just need to repeat your original formula is place of the "yourfunction" and change the "0" to what you would like to be displayed when an error occurs.
