rounding to closest 5 cents

I am using Excel 2003

How do you round the contents of a cell to the closest five cents.

Thanks
lk

=MROUND(A1,0.05)

Vaya con Dios,
Chuck, CABGx3




"lk" <[email protected]> wrote in message
news:[email protected]...
> I am using Excel 2003
>
> How do you round the contents of a cell to the closest five cents.
>
> Thanks
> lk
>
>

=ROUND(C10*20,0)/20

--

HTH

RP
(remove nothere from the email address if mailing direct)


"lk" <[email protected]> wrote in message
news:[email protected]...
> I am using Excel 2003
>
> How do you round the contents of a cell to the closest five cents.
>
> Thanks
> lk
>
>

When I try to use this function I get the error "#NAME?"
lk

"CLR" <[email protected]> wrote in message
news:%[email protected]...
> =MROUND(A1,0.05)
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
>
> "lk" <[email protected]> wrote in message
> news:[email protected]...
>> I am using Excel 2003
>>
>> How do you round the contents of a cell to the closest five cents.
>>
>> Thanks
>> lk
>>
>>
>
>

Thanks "CLR" it works I needed to install the analysis toolpack
lk

"lk" <[email protected]> wrote in message
news:[email protected]...
> When I try to use this function I get the error "#NAME?"
> lk
>
> "CLR" <[email protected]> wrote in message
> news:%[email protected]...
>> =MROUND(A1,0.05)
>>
>> Vaya con Dios,
>> Chuck, CABGx3
>>
>>
>>
>>
>> "lk" <[email protected]> wrote in message
>> news:[email protected]...
>>> I am using Excel 2003
>>>
>>> How do you round the contents of a cell to the closest five cents.
>>>
>>> Thanks
>>> lk
>>>
>>>
>>
>>
>
>

On Tue, 29 Mar 2005 21:36:12 +1000, "lk" <[email protected]> wrote:

>I am using Excel 2003
>
>How do you round the contents of a cell to the closest five cents.
>
>Thanks
>lk
>

If you have the Analysis ToolPack installed:

=mround(A1,0.05)

If you do NOT have the ATP installed:

=ROUND(A1/0.05,0)*0.05


--ron