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:
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. 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.
