Rounding negatives to Zero

  • Thread starter Thread starter wbullock
  • Start date Start date
W

wbullock

I am trying to use the rounding feature - but what I need it to do is..
if the original number is negative then round it to zero.

I can do this with round but if the number is .46 then it rounds it t
0 - when I need that to be 1.

Any help would be great
 
wbullock > said:
I am trying to use the rounding feature - but what I need it to do is...
if the original number is negative then round it to zero.

I can do this with round but if the number is .46 then it rounds it to
0 - when I need that to be 1.

Any help would be great.
Click to expand...


Rounding means to take the closest number of significance, so you cannot
'round' to zero. Do you mean that you want all negative numbers to result in
zero, whereas all positive numbers are rounded up to the nearest integer? If
so, use
=MAX(0,ROUNDUP(A1,0))
If not, please explain what you do mean.
 
I am trying to use the rounding feature - but what I need it to do is...
if the original number is negative then round it to zero.

I can do this with round but if the number is .46 then it rounds it to
0 - when I need that to be 1.

Any help would be great.
Click to expand...


=MAX(0,ROUNDUP(A1,0))


--ron
 
Back
Top