How do I round down currency in Excell?

From: NTG (NTG_at_discussions.microsoft.com)
Date: 10/12/04 

Date: Mon, 11 Oct 2004 21:13:03 -0700

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?

Relevant Pages

  • Re: Hillary Clinton Gives Driving Advice
    ... Right now we round every price to the nearest $0.01; ... would have to do would be to round to the nearest $0.1 instead. ... How about restoring value to currency instead of inflating it? ...
    (rec.autos.driving)
  • Re: How do I round down currency in Excell?
    ... "NTG" wrote in message ... > I was trying to get the currency to round down to the nearest 5 cent ...
    (microsoft.public.excel.misc)
  • Re: Hillary Clinton Gives Driving Advice
    ... Right now we round every price to the nearest $0.01; ... would have to do would be to round to the nearest $0.1 instead. ... How about restoring value to currency instead of inflating it? ...
    (rec.autos.driving)
  • Re: Rounding to
    ... this is a little more complicated than just rounding. ... figure which is multiplied by column D to get the amount in column F. So ... I want to round them to the nearest 50, ...
    (microsoft.public.excel)
  • Re: rounding
    ... "dodge" schrieb im Newsbeitrag ... > how do I round a currency value to the nearest 5c. ...
    (microsoft.public.excel.worksheet.functions)