Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Yellow Triangle in Formula Cell

Request Demo

I'm noticing that some of my formula cells, which usually have a green triangle in the bottom right to indicate a formula is in use, have turned from green to yellow triangles. Does anyone know why they would have changed to yellow or what the yellow triangles mean?

Thanks!

2

Comments

3 comments

Date Votes
  • Chuck

    Interested to know more about this change.

    0
  • Isabel Messore

    Welcome to the Community Joe White and welcome back Chuck!

    Long story short, the yellow triangle means your formula is correct however, the number displayed is different from the exact value. I can give some more background as to why this might happen as well!
     
    Essentially, when using formulas, users are able to set whether the formula calculates in "full precision" or "as displayed" -- by default, I believe formulas calculate at full precision. You can change the global default for a file in the file properties. You can also change this at a more granular level by changing the setting "value format option for the cell properties" to "as displayed". 
     
    Any time a formula is presenting a different value compared to the other calculation method, the green triangle in the bottom right will turn yellow instead to warn that they should double check the values are appearing as they expect.
     
    Hope this provides some insight!
    0
  • Joe White

    Thanks for your reply Isabel Messore! This was a big help. 

    0

Please sign in to leave a comment.