Microsoft Excel frequently get errors which can be very frustrating for their users. Errors can occur in Office programs due to issues with your Office program or if you might do something wrong in your document, slide, or Excel spreadsheet. In this post, we will show you how to fix the #NULL error in Excel.
Why does #NULL appear in Excel?
The #NULL error occurs when you use an incorrect range operator in a formula or when you use an intersection operator (space character) between range references. The #NULL error specifies that the two ranges do not intersect.
How to fix the #NULL error in Excel
Follow the methods below to fix the #NULL error in Excel:
- Insert a Colon
- Insert a Comma
1] Insert a Colon
If you are using a space in your formula or an incorrect operator, for example, =SUM(A2 A3), Excel will return the #NULL error.
To fix this issue, you should use the colon to separate the first cell from the last cell, for example, =SUM(A2:A3). The colon is used to separate when you refer to a continuous range of cells in a formula.
2] Insert a Comma
Excel will return a #NULL error when you refer to two areas that do not intersect, for example, =SUM(A2:A3 B2:B3).
If the formula sums two ranges, make sure that a comma separates the two ranges =SUM(A2:A3, B2:B3).
How do I get rid of green error in Excel?
Whenever you get an error in your spreadsheet, you will see a green triangle on the left of the cell, where the error is; Follow the steps below to turn off the green triangle.
- Click the File tab.
- Click Options on the backstage view.
- An Excel Options dialog box will open.
- Click the Formulas tab on the left pane.
- Under the Error Checking section, uncheck the check box for ‘ Enable background error checking.
- Click OK.
- The green triangle in the error cell is removed.
Read: How to change Direction of the Enter key in Excel
We hope this tutorial helps you understand how to fix the Null error in Excel; if you have questions about the tutorial, let us know in the comments.