Multiple Condition rounding functions

[Andrian2712]

Hello, i got a little problem to my rounding function, i got an example
Aaron = 120,200
Bella = 120,350
Charlie = 120,670
Dean = 120,880

i wanted to round to
Aaron = 120,000
Bella = 120,500
Charlie = 120,500
Dean = 121,000

So far, i got into this mess, working formula, but not intended (im using R11 cell as example)
=IF(MOD(R11;1000)<=250;ROUNDDOWN(R11;-3);IF(MOD(R11;1000)>250;ROUNDUP(R11;-3);IF(MOD(R11;1000)<=750;ROUNDDOWN(R11;-3);IF(MOD(R11;1000)>750;ROUNDUP(R11;-3)))))
with this formula, i got the rounding a lil messed up, example
Aaron = 120,000
Bella = 121,000
Charlie = 121,000
Dean = 121,000

Any help or comments really appreciated

Thankyou

 

[hagia_sofia]

If I understand it correctly, then:

=MROUND(A1,0.5)

 

[Andrian2712]

If I understand it correctly, then:

=MROUND(A1,0.5)

hello, thanks for your reply, but i think you got it wrong, its 120,000 "one hundred and twenty thousand", not in decimals, and from i know, if i use that function you gave, the formula will still be working, but not as i intended.

 

[hagia_sofia]

Ah, sorry, my bad. I do not know about your data structure but would it not be possible to divide your original data by 1,000, then use MROUND, and then multiply by 1,000, i.e.

=MROUND(A1/1000,0.5)*1000

 

[FormR]

divide your original data by 1,000, then use MROUND, and then multiply by 1,000

Hi, why not just

=MROUND(A1,500)

instead.