MRound Not working

[Pc1x1]

I am trying to round numbers up and down automatically. But I need them to round to the nearest .5. I used MRound, but the problem is in MRound .5, 74.55 rounds down to 74.5, etc. If I change it and do I round first, etc, then the others numbers are off. I just want if #.5 > Round Down, if # < .5 Then round up.

I may just have answered my own question using IF statements, but if anyone has any suggestions, please let me know.

102.90 Needs to become 103
74.55 Needs to become 75
141.75 Needs to become 142
56.39 Needs to become 56.5

But the problem I am having is how can it determine that the decimals is .5 or not. Still not getting it to work, but fairly close.

 

[Juan Pablo González]

Use CEILING instead

=CEILING(A2,0.5)

 

[danzon]

Try this.... it works for the examples that you gave at the bottom of your post...

assume your data starts in A1

in B1 use
=CEILING(A1,0.5)

and drag down as needed

 

[Pc1x1]

Perfect, Thanks guys.

The only Error, I see, is

75.08, it brings up to .5 but I guess thats inevitable? IE can you put parameters so if thats low, it goes down instead?

IE. 75.08 becomes 75.5

 

[Juan Pablo González]

Lower than what? the specifications aren't very clear...

 

[jasonb75]

Maybe something like

=MROUND(B16+0.15,0.5)

The 'error' you mention in #4 appears to contradict the objective in #1

 

[asad]

Maybe something like

=MROUND(B16+0.15,0.5)

The 'error' you mention in #4 appears to contradict the objective in #1

Instead of 0.15, I think it should be 0.25. I could be wrong but try 0.25 if 0.15 does not work.

 

[Scott Huish]

It sounds like you just want to round to a multiple:

But this example seems contradictory:
74.55 Needs to become 75


It is low, why not 74.5?

If it should be 74.5 then this should do what you want:

=ROUND(A1*2,0)/2

 

[asad]

Choose which ever suits you.

Excel Workbook
	A	B	C	D
2		ROUND(A4*2,0)/2 will yield	MROUND(A4+0.25,0.5) will yield	MROUND(A4+0.15,0.5) will yield
3
4	74.08	74	74.5	74
5	74.39	74.5	74.5	74.5
6	74.55	74.5	75	74.5
7	74.78	75	75	75
Sheet1

 

[Pc1x1]

Thanks guys, perfect examples.