Are they just number constants, or the result of a formula. If the latter,
use something like

=IF(formula<0,0,formula) or = MAX(0,formula)

and

=IF(formula60,60,formula) or =MIN(60,formula)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Decopk" wrote in message
...
I'm trying to make a worksheet and I need any number over 60 to be equal
to
60. Or how can I make any negative number a zero? Please help, I've
tried
everything!!!