Anyone know a good way to round so that a prices can end up in 50 cent
increments?
28.10 would round down to 28.00
28.40 wound end up 28.50
28.80 would end up 29.00

Try one of these:

For a value in A1

B1: =MROUND(A1,0.5)
or
B1: =ROUND(A1/0.5,0)*0.5

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"widman" wrote:

Anyone know a good way to round so that a prices can end up in 50 cent
increments?
28.10 would round down to 28.00
28.40 wound end up 28.50
28.80 would end up 29.00

Yep, the second one did it. Excel did not recognize "mround" as a formula.

thanks

"Ron Coderre" wrote:

Try one of these:

For a value in A1

B1: =MROUND(A1,0.5)
or
B1: =ROUND(A1/0.5,0)*0.5

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"widman" wrote:

Anyone know a good way to round so that a prices can end up in 50 cent
increments?
28.10 would round down to 28.00
28.40 wound end up 28.50
28.80 would end up 29.00

Not sure if this is the most efficient of formulas, but i works for
me:-

=IF((A1-INT(A1))<0.25,FLOOR(A1,0.5),IF((A1-INT(A1))=0.75,CEILING(A1,0.5),IF((A1-INT(A1))<0.5,CEILING(A1,0.5),FLOOR(A1,0.5))))

Assuming your value is in A1, if there are to be negative numbers, you
may need to alter the formula to calculate on Absolute values

G


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=536862

Excel did not recognize "mround" as a formula.

The MROUND function is part of the Analysis Tool-Pak add-in. In
order to use it, you must go to the Tools menu, choose Add-Ins,
and select Analysis Tool-Pak from the list. Once you've checked
this item, the MROUND function will be available for use.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"widman" wrote in message
...
Yep, the second one did it. Excel did not recognize "mround"
as a formula.

thanks

"Ron Coderre" wrote:

Try one of these:

For a value in A1

B1: =MROUND(A1,0.5)
or
B1: =ROUND(A1/0.5,0)*0.5

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"widman" wrote:

Anyone know a good way to round so that a prices can end up
in 50 cent
increments?
28.10 would round down to 28.00
28.40 wound end up 28.50
28.80 would end up 29.00