Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Alston, UK
    Posts
    3
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Question round up to next 0.05

    I'm trying to get a cell to display a value rounded to the next 5 pence up

    =MROUND(A1,0.05)
    is my best attempt but it somtimes rounds down
    eg 0.44 rounds up to 0.45 but 0.42 rounds down 0.40

    Any ideas please?

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Steve,

    If I understand your requirement correctly this should do the trick: =FLOOR(A1+0.04,0.05)
    Attached Images Attached Images
    Last edited by RetiredGeek; 2012-01-19 at 11:50.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    near Boulder, Colorado, USA
    Posts
    112
    Thanks
    22
    Thanked 4 Times in 4 Posts
    CEILING function is simpler:
    =CEILING(A1,0.05)

  4. The Following User Says Thank You to cosmlou For This Useful Post:

    steve.prentice (2012-01-20)

  5. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Quote Originally Posted by cosmlou View Post
    CEILING function is simpler:
    =CEILING(A1,0.05)
    Duh! Right you are.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  6. The Following User Says Thank You to RetiredGeek For This Useful Post:

    steve.prentice (2012-01-20)

Posting Permissions

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