June 14, 2018

Excel’s two error trapping functions

Excel has two error detection functions that are almost identical: ISERR and ISERROR. Their syntaxes are identical:
ISERR(value) and ISERROR(value). They will both return True if the value throws an error. The difference is the ISERROR function will detect #N/A errors and ISERR won’t.

Categories

Share:

Related Posts

Between the Sheets — Excel podcast episode 45: using the Let function

In partnership with Experts Exchange. Introduced in the 365 editions of Excel, the Let function lets you define variables, their values and calculations that use

Adobe artificial intelligence feature: Generative Recolor

Adobe just introduced the beta of an artificial intelligence feature for Illustrator called Generative Recolor. As the name suggests, it will recolor artwork for you.

Between the Sheets — Excel podcast episode 34: Artificial intelligence tools like ChatGPT in Excel

In partnership with Experts Exchange. Artificial intelligence is causing a major disruption in information technology. In this episode, we test how well three AI tools

Between the Sheets — Excel podcast episode 44: combining the Take and Filter functions

In partnership with Experts Exchange. The Take and Filter functions are both new in the 365 editions of Excel. By combining them in a formula,

Experts Exchange Adobe Expert (me)

Experts Exchange named me as the leading expert for Adobe Creative Suite. Check out my tutorial on the new artificial intelligence features in Photoshop.