#### ShopManager

##### New Member

- Joined
- Dec 4, 2016

- Messages
- 3

I have an excel spreadsheet that I use to markup pricing on parts. My formula is pretty easy, however I would like it to use the roundup function as well. Basically, I want it to do the existing formula (=SUM A6/0.29) and then round up. Most of the time it comes up with a number like $ 2.24. Is there a way to get it to round up to either a $4.99 or $9.99? So anything that is less than $4.99 would round up to that and $5.00 and above would round up to $9.99?

Thanks for any help you can give me!