No circular references (when a formula or function references itsself) was one of the essentials in my Five Formulas and Functions Essentials post. Generally, if you have a circular reference, you’ll get an error message warning you about it. But the message doesn’t tell you where your circular reference is. And if you click Cancel on the [...]
Tag archives for Error
Nesting IF and ISNUMBER to Hide Errors
Sometimes, even when a formula is working correctly, it will return an error, like #N/A or #VALUE!. If you’re sharing your worksheet with someone else, or if you just like a tidy worksheet, you may not like seeing these errors. Fortunately, nesting ISNUMBER into an IF function can eliminate them. The ISNUMBER function checks to see [...]
category: Excel
About
The McCombs Technology Training Team helps UT Austin business students, faculty, and staff with their technology resources, and with Microsoft Office. The trainers are Holly Green and Ben Bond.
Jeff Hauger, a previous team member, contributed several blog posts.
