Hi
try
=MIN(your_formula,0)

--
Regards
Frank Kabel
Frankfurt, Germany

Wayne wrote:
I am trying to write a formula so that it displays all negative
results but defaults to zero if the answer is any positive number.