While performing some Mathematical calculation in excel many error comes as result as #DIV/0!
To hide these errors in the result use combination of IF, ISERROR and your calculation like this.
=IF(ISERROR(C4/D4),0,C4/D4)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment