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

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

=if(c16<0,0,c16)


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=564093