|
Los tipos de archivo clásicos dejarán de estar disponibles a partir de enero de 2021. Puedes migrar tus archivos clásicos o descargar un PDF. Más información

Show larger than zero as zero, and zero as blank

Solicitar demostración

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! 

1

Comentarios

2 comentarios

Fecha Votos
  • 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

Iniciar sesión para dejar un comentario.