Round up-down-or middle
 

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

Round up-down-or middle
 

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

Round up-down-or middle
 

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

Round up-down-or middle
 

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

Round up-down-or middle
 

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