make a negative number zero
If your data is computed via formulas you could add logic to your formulas
EX. IF(A1+B1<0,0,A1+B1) etc.....
If your data is hard coded EX. 1, 5, -3, etc.... I think you would have to
pick another area and/or worksheet and add formulas to it EX. IF(hardcoded
data <0,0,hardcoded data) etc...
Hope this helps.
Thanks,
Bill Horton
"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!!!
|