I am using Excel 2003
How do you round the contents of a cell to the closest five cents.
Thanks
lk
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks