Rounding question-- For dsitribution calc.

[MartyCollins]

Hi there,
So i have a list of parts and for each part im calculationg where it is in its lifecycle.
Most parts fall somewhere between 0% and 100%, and then some are above and below.
(This is actually a powerbi problem but if I solve it in excel ill be able to solve it there)

I have calculated Bins for each item so that i can see the distribution-- eg all parts between 50 and 60% get a bin of "50"-- parts between 60 and 70 get a Bin of 60.

My problem is near zero, im using rounddown on the % eg roundown(A2,-1) to bring my Bin values to the nearest 10 below...BUT this is bringing all parts > -10% - > + 10% to 0.

Im looking for a formula of function to bring 0->+10 to zero and also bring -10 -> 0 to -10.

Im thinking an if to see whats below zEro and then treat it differently, howver i can think what will round down a negative number to the nearest 10 below it (eg bring -55 to -60)

TIA,
MArtin.

 

[MartyCollins]

OK this was staring me in the face-- if less than zero roundup..

 

[Scott Huish]

I think you could use this as the formula:
=INT(A1/10)*10

 

[Phuoc]

Try this:

=FLOOR(A2,10)

 

[MartyCollins]

Thanks Both - they both work perfect too- ive already used the if statement to switch between roundup and rounddown-- ill swap it out for floor when ive it open again onMonday.
Thanks again for your awesomeness