Using ROUNDUP with an existing formula

claromatt

New member
Joined
Sep 16, 2019
Messages
3
Reaction score
0
Points
0
Location
ABQ
Excel Version(s)
16.29
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
 
If you need to roundup to the nearest multiple of 0.05 try =CEILING((e16/h16)+0.35,0.05)
 
Thanks so much—both of you!!

Pecoflyer—that's exactly what I needed! I am so happy I could spit!
 
Last edited:
Back
Top