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 spreadsheet 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 spreadsheet 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 ]
Relevant Pages
|
