クラシックファイルタイプは、2021年1月をもって使用不可となりました。クラシックファイルを移行するか、PDFをダウンロードすることができます。 詳細を見る

Yellow Triangle in Formula Cell

デモをリクエスト

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

コメント

3件のコメント

日付 投票
  • 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

サインインしてコメントを残してください。