Exel formula

F

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
 
N

Niek Otten

Hi Tanja,

=MAX(YourOriginalFormula,0)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
 
Top