Hi Tanja,

=MAX(YourOriginalFormula,0)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Farnorth" wrote in message ...
|I need a formula to enter into a cell, that tells it if the value of the cell
| is < 0 it must show it as 0, and if the value is 0 or 0 it must show it as
| the original value.
| I.e. if it's a negative value - display 0
| if its a positive value - display the true value
| Tanja