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
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
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks