Excel help: how do I round numbers?

I've got this column full of MSRP prices and I'm dying to round them to the nearest $0.00... For example,
if an MSRP hits between 500.00 and 505.00, I want it to snap down to 500.00. But if it's between 505.01 and 509.99, let's bump it up to 510. Basically, I need that logic applied to the whole column.
Hope that makes sense! Thanks a ton

wanderingmoose59 said:I have this column filled with MSRP prices, and I’m looking to round them all to the nearest $0.00... For instance,
if a price sits somewhere between 500.00 and 505.00, I want it rounded down to 500.00—but if it's between 505.01 and 509.99, I want it bumped up to 510.00, and so on, applied consistently across the whole column.
I hope I made myself clear enough, and thanks in advance.

The first guy here who refuses to round anything except upwards, I suppose. 🙂

Using =ROUND(A1,-1) should accomplish exactly what you need for the value in cell A1.

Look, if you’re trying to force a number like 2.7 up to a 3—you know, always rounding up to be safe—just use the formula: =ROUNDUP(2.7,1). On the flip side, if you need to pull a 2.1 down to a 2, go with: =ROUNDDOWN(2.1,1). And honestly, I was dealing with this headache the other day at my desk when I needed to turn 505.00 into a clean 500 by rounding down: just use =ROUNDDOWN(505,-1). It saves a lot of unnecessary math if you just set it right from the start.

Walter Jackson48 said:If you want to, say, round 2.7 up to 3, you should use the formula: =ROUNDUP(2.7,0)—well, actually, if you want to round 2.1 down to 2, you’d use =ROUNDDOWN(2.1,0). And if you were looking to turn 505.00 into 500, you’d go with =ROUNDDOWN(505,-1).

Look, I guess ROUNDUP and ROUNDDOWN aren't really addressing what this person is actually asking for—they seem to be looking for "standard" rounding rules.

Yo, I need a hand with this rounding stuff :npr

484.54 to 480
487.11 to 490
484.99 to 480
485.01 to 490

Basically, only 480.00, 485.00, and 490.00 stay put—everything else gets rounded...

Not sure if I can pull this off without using an IF statement in the formula...🤷

See, Nicholas King, I'm not just rounding up👍

wanderingmoose59 said:Actually, I could use some help figuring out these specific rounding rules—for example:

484.54 down to 480
487.11 up to 490
484.99 down to 480
485.01 up to 490

😕😕😕

I suppose I can only state this one more time:

=ROUND(A1,-1) should perform exactly what you need for the value sitting in cell A1.