Results 1 to 4 of 4

Thread: Using ROUNDUP with an existing formula

  1. #1
    Neophyte claromatt's Avatar
    Join Date
    Sep 2019
    Location
    ABQ
    Posts
    2
    Articles
    0
    Excel Version
    16.29

    Using ROUNDUP with an existing formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello! This is my first post, and I'd like to start by thanking this forum for existing!
    I am an absolute beginner with Excel, so I feel a bit underwater…especially tackling formulas.
    Here's what I need to figure out—the existing formula simply divides data from two separate columns and adds 0.35, but I need to then have it round up to the nearest multiple of 0.05 (or the nearest nickel since this calculates the price of an item). With my limited grasp of MROUND and ROUNDUP, I have only been able to achieve rounding up to the nearest whole dollar (+/-)…

    Can anyone help? I am assuming this is child's play for some of you:

    =(E16/H16)+0.35

    this is the orginal formula that I want to add the rounding to.

    Thanks so much folks!!

    An appreciative Matt

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    186
    Articles
    0
    Excel Version
    2019
    =mround((e16/h16)+0.35,0.05)

  3. #3
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,673
    Articles
    0
    Excel Version
    2010 on Xubuntu
    If you need to roundup to the nearest multiple of 0.05 try =CEILING((e16/h16)+0.35,0.05)
    Thank you Ken for this secure forum.

  4. #4
    Neophyte claromatt's Avatar
    Join Date
    Sep 2019
    Location
    ABQ
    Posts
    2
    Articles
    0
    Excel Version
    16.29
    Thanks so much—both of you!!

    Pecoflyer—that's exactly what I needed! I am so happy I could spit!
    Last edited by claromatt; 2019-09-16 at 04:48 PM.

Posting Permissions

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