claromatt
New member
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
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