I have a massive spreadsheet where in many cases the formula gives a #NUM! result if there is not a value in each of the referenced fields corresponding to the formula. I don't know how to eliminate them. Please help |-0
The following are "error handling" formulas. If you would like a value (like zero), replace the "" with that value. If you would like text, such as Not Found, place the exact text between the ""s.
To hide DIV0#, #NUM, etc.:
=IF(ISERROR(A1*B1),"",A1*B1)
To hide #NA errors:
=IF(ISNA(A1*B1),"",A1*B1)
To return nothing ("" when either calculating cell is blank:
=IF(OR(ISBLANK(A1),ISBLANK(B1),"",A1*B1)
techsupportgirl@home.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.