Re: How do I round down currency in Excell?

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 10/12/04

Next message: Devitt: "How do i search a spread*** without a full word?"
Previous message: MorusB: "Disappearing Pics in Header - Excel 2003"
In reply to: NTG: "How do I round down currency in Excell?"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 12 Oct 2004 08:43:18 +0100

Always down?

=ROUNDDOWN(A1/0.05,0)*0.05

Also , see http://www.xldynamic.com/source/xld.Rounding.html#fractions

-- 
HTH
RP
"NTG" <NTG@discussions.microsoft.com> wrote in message
news:61E13725-FBC5-4929-90D6-38B35F216710@microsoft.com...
> I was trying to get the currency to round down to the nearest 5 cent
> interval, the amount is $34,047.96, I need to get it to $34,047.95 because
> their are no 1 cent coins in Australia and It's part of a formula that
needs
> to update when figures are changed, dose anyone know how I can do this?

Next message: Devitt: "How do i search a spread*** without a full word?"
Previous message: MorusB: "Disappearing Pics in Header - Excel 2003"
In reply to: NTG: "How do I round down currency in Excell?"
Messages sorted by: [ date ] [ thread ]