make a negative number zero
You can't just "change a number from what it is to something else", unless
you run a macro after entering the numbers..........if what you are wanting
to do is tailor the results of a formula, then
=IF(SUM(A1:A3)<0,0,MIN(SUM(A1:A3),60))
Replace SUM(A1:A3) with the formula you are using..........
Vaya con Dios,
Chuck, CABGx3
"Decopk" wrote:
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!!!
|