Hi
You can do that with formatting or you could use something like:
=IF(yourformula<0,0,yourformula)

--
Andy.


"Penfold" wrote in message
...
I need to create a formula that says if the value is a minus or 0 show 0.00
if there is a positive value show the value.