displaying values

P

ptutini

I need help with a formula:

If the value of a cell is a negative number, display 0, but if the
value in the cell is a positive number, display the value.
 
P

Pete_UK

If you wanted to do this with a formula you would have to enter the
formula in a separate cell. However, you can do it with formatting.
Select the cell and Format | Cell | Custom and enter:

0.0;"0";"0"

Both zero and negative numbers will be displayed as 0, positive numbers
as 1 decimal place.

Hope this helps.

Pete
 
Top