Rounding negatives to Zero

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
 
P

Paul

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.
 
R

Ron Rosenfeld

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
 
Top