+ Reply to Thread
Results 1 to 3 of 3

"Rounding" to nearest 5 cents

  1. 10-10-2011, 10:21 PM #1
    TOMMUIR
    TOMMUIR is offline
    Registered User
    Join Date
    10-10-2011
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003
    Posts
    2

    "Rounding" to nearest 5 cents

    Am trying to find a formula which will "round" a dollar/cents value to the nearest 5 cents. Have tried all the "rounding" formulae I could find but can only get to the nearest 10 cents.
    Reason for question is that in Australia our smallest denomination coin is 5 cent piece.
    Any ideas?
    Reply With QuoteRegister To Reply
  2. 10-10-2011, 11:00 PM #2
    EdWoods
    EdWoods is offline
    Forum Contributor
    Join Date
    09-29-2011
    Location
    ɹǝpun uʍop
    MS-Off Ver
    365
    Posts
    250

    Re: "Rounding" to nearest 5 cents

    Try
    Please Login or Register  to view this content.
    (Where A1 is the value to be rounded)

    If you don't have MROUND function, you can do it manually

    Please Login or Register  to view this content.
    Last edited by EdWoods; 10-10-2011 at 11:17 PM.
    Reply With QuoteRegister To Reply
  3. 10-11-2011, 12:43 AM #3
    TOMMUIR
    TOMMUIR is offline
    Registered User
    Join Date
    10-10-2011
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: "Rounding" to nearest 5 cents

    Thanks Ed. The manual version works a treat!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1