Results 1 to 4 of 4

Thread: Rounding down to nearest nickel

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2001
    Location
    Mass USA
    Posts
    1,674

    Rounding down to nearest nickel

    Is there a vb function that would allow me to round down to the nearest nickel or should I just write something that will change it as a string?

  2. #2
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: Rounding down to nearest nickel

    U will need to write your own function
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

  3. #3
    Frenzied Member cssriraman's Avatar
    Join Date
    Jun 2005
    Posts
    1,465

    Re: Rounding down to nearest nickel

    @ Besoup

    Can you show us an example, what you would like to achieve?
    CS

  4. #4
    Oi, fat-rag! bushmobile's Avatar
    Join Date
    Mar 2004
    Location
    on the poop deck
    Posts
    5,592

    Re: Rounding down to nearest nickel

    VB Code:
    1. Private Function RoundDownToNickel(ByVal dblAmount As Currency) As Currency
    2.     RoundDownToNickel = dblAmount - (((dblAmount * 100) Mod 5) / 100)
    3. End Function

Posting Permissions

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



Click Here to Expand Forum to Full Width