Forum Discussion
Derek1940
Jun 05, 2020Copper Contributor
Excel spreadsheet
I keep getting a small triangle in the top left corner of my formula when I am simply wanting to TOTAL a row of accounting numbers.. What does it mean?
2 Replies
- Haytham AmairahSilver Contributor
Hi Derek,
There are several reasons to have this triangle.
You will see this triangle when your data violate the error checking rules in Excel.
You can see these rules in Excel Options as follows:
To know which rule of them your formula violates, click the dropdown list next to the cell:
Hope that helps
Regards
- Detlef_LewinSilver Contributor
Click on the cell. An icon with a dropdown shows on the left of the cell. Click on the dropdown and it will tell you what the problem might be and sometimes also a solution.