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.

FormatCellsNumber tabCustom
In the Type box, enter

#0;"0"

--
Kind regards,

Niek Otten

wrote in message
oups.com...
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.

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

Explain it again, but differently, use examples.

" wrote:

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.