Sometimes a formula may return an error message
but you may want to avoid the messages.
You can do so by using an IF() function to check for an error.
The formula below displays a blank if the division results in an error.
=IF(ISERROR(A1/B1),"",A1/B1)
No comments:
Post a Comment