Rounding negatives to Zero

[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

 

[Paul]

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.

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.

 

[Jason Morin]

=(A1>0)*ROUNDUP(A1,0)

HTH
Jason
Atlanta, GA

 

[wbullock]

Thnak you for your help - that worked perfect

 

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

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


--ron