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
|