# Thread: Using ROUNDUP with an existing formula

1. ## Using ROUNDUP with an existing formula

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. =mround((e16/h16)+0.35,0.05)

3. If you need to roundup to the nearest multiple of 0.05 try =CEILING((e16/h16)+0.35,0.05)

4. Thanks so much—both of you!!

Pecoflyer—that's exactly what I needed! I am so happy I could spit!

#### Posting Permissions

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