Bob
I was working on the theory that the cell would be formatted as 0.00, and
therefore the formula wouldn't need to check for being zero itself!

--
Andy.


"Bob Phillips" wrote in message
...
=IF(yourformula<=0,"0.00",yourformula)


--
HTH

Bob Phillips

<Andy B wrote in message ...
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.