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

If you want to display the formula in cells instead of calculated results in an Excel spreadsheet, here is how you can do that. It is possible to show the used or applied formula and hide the ...

and #NULL! errors ... functions to test the values in column A. If your IS formula references a cell in a formatted Excel table, the value in the parentheses would be the column name.