tag:blogger.com,1999:blog-1869924468172210809.post9087688016924128559..comments2024-03-22T10:09:26.517+00:00Comments on Not Just Numbers: Excel Tip: Eliminating #DIV/0! and other errors - an updateGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1869924468172210809.post-62842659916821607502014-10-23T19:12:44.291+01:002014-10-23T19:12:44.291+01:00I like it for vlookups best... if the target data ...I like it for vlookups best... if the target data doesn't include the string you're looking for you can return 0 where the lookup returns an error and then include the 0 result in formulae... e.g. comparing two TBs. Rather than masking errors, in this circumstance it prevents the basic vlookup indicating errors where there aren't any.<br /><br />AdamAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-24170283463040561832014-10-21T13:03:25.673+01:002014-10-21T13:03:25.673+01:00Eric
That's a good point. I think it comes do...Eric<br /><br />That's a good point. I think it comes down to the risk involved in the specific scenario, and personal preference.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-74402959612867762162014-10-21T12:44:37.580+01:002014-10-21T12:44:37.580+01:00Hi Glen,
Personally I do not like this kind of er...Hi Glen,<br /><br />Personally I do not like this kind of error-trapping <br />it also masks all other errors <br />why not just check if the divisor is zero?<br />= if (b1 = 0, "", a1 / b1)<br /><br />best,<br />EricAnonymousnoreply@blogger.com