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



3 opmerkingen

  • Chuck

    Interested to know more about this change.

  • 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!
  • Joe White

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


U moet u aanmelden om een opmerking te plaatsen.