Forum Discussion

Derek1940's avatar
Derek1940
Copper Contributor
Jun 05, 2020

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 Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Derek1940

     

    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_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Derek1940 

    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.

Resources