in thecellwhere the formula is located.
The green triangle indicates that the cell contents violate one of Excel’s error checking rules.
When you select a cell containing a green triangle, a yellow diamond-shaped button appears next to the triangle.
The yellow diamond is Excel’s error options buttonand it contains options for correcting the perceived error.
#NULL!
Errors Incorrectly Separated Cell References
#NULL!
error values occur when the two or morecell referencesare separated incorrectly or unintentionally by a space in a formula.
errors occur if:
The solutions to these problems is to separate cell references correctly.
Here are a few tips:
#REF!
Errors Invalid Cell References
An invalid cell reference error pops up if a formula contains incorrect cell references.
This happens most often when:
When you encounter a #REF!
error, try these solutions:
#DIV/O!
Errors Divide by Zero
Divide by 0 errors triggers when a formula attempts to divide by zero.
This can be caused when:
When you encounter a #DIV/O!
It is brought on by the length of data entered into a formatted cell.
The row of ##### occurs in a variety of instances.
For example:
Here’s how to fix a ##### error:
