Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Excel Formula Error Messages

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Back to Excel Model Builder Start

Formula's error  
This useful tool detects whenever one enters data that will cause an error in the formula.

Follow these steps:
1.- Select a range containing formulas.
2.- Click on the corresponding button. The dialogue box shown below will appear.
3.- Enter the data as applicable.

The message customized by user can be text, a cell's address, a formula, or nothing.
If a formula, it must be preceded by the equal sign.
Finally, click OK and watch how, in the formulas bar, the active cell's formula has changed.
Let us make an error on purpose, so we can see the tool in action.
When there is an error, the message we had previously configured will show the following (look at the cells marked in red):
This task can be undone by clicking on the Excel Undo button.

Back to Excel Model Builder Start

Excel Model Builder  $159.95 Secure Payment Options

30 Day Money Back Guarantee

Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH!  Purchases MUST be made via this site. Send payment confirmation to [email protected] 31 days after purchase.


Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us