Show larger than zero as zero, and zero as blank
Hi,
We are using accounting formatting in spreadsheet, and for a specific report we are looking for a solution to the following display formatting:
- If a number is zero => display blank or en dash
- If a number is between 0 and 1 => display "0"
- If a number is between -1 and 0 => display "(0)"
It is important that only the way the number is displayed is changed, not that the value of the cell.
Are there and suggestions to how we can solve this?
Thank you!
-
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
Hi - are there any more formatting solutions to this issue? I am encountering a similar problem.
0請登入寫評論。
評論
2 條評論