[SOLVED] Exel formula

[Farnorth]

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

[Niek Otten]

Hi Tanja,

=MAX(YourOriginalFormula,0)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Farnorth" <[email protected]> wrote in message news:[email protected]...
|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

[davesexcel]

=if(c16<0,0,c16)