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

Show larger than zero as zero, and zero as blank

0

コメント

2件のコメント

  • Andrew McKenzie

    Rune Ingebrethsen - if you haven't tried this already, you could create a new column and populate its cells using an IFS formula to display output values dynamically from the input values based on the rules you outline. This way the original values are also left intact in the original column.

    Based on my very quick test, with the right formula and formatting configuration this appears to achieve a result similar to what you are looking for, with the caveat that I couldn't get the currency symbol to show up for the second and third cases. So definitely not perfect, but maybe a start.

    Curious if anyone else has a better or more complete solution.

    0
  • Jack Bainbridge

    Hi - are there any more formatting solutions to this issue? I am encountering a similar problem.

    0

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