Hi! Thank you in advance and sorry if I missed this in another thread.
I own a store and need to raise all of my prices by 3% and rounded-up to the nearest 9 cents. So if a price is currently $18.99 and I multiply it by .03 it is now 19.5597.
Can anyone show me what formula I use if say field F4 is 19.5597 and I want to roundup to the nearest 9 cents (so in this case it would round up to 19.59) ?
I want to copy and paste a formula into the Excel sheet that has all of my prices, so I will then have a new column next to the old prices that has all the new prices (multiplied by .03 and roundedup to the nearest 9 cents) that can then be imported into my point of sale system.
Thank you!
Bookmarks