Forum Discussion
Justin928
Sep 30, 2020Copper Contributor
Round Up in Excel
Hi all, I need help with a formula to round up to the nearest 9. My goal is to use Excel for markups/pricing. For example $1.23 * 1.72% = $2.12. I want to round to the nearest 9, from 2.12 to 2.19. I have used the round up function and was able to go to $2.99, =ROUNDUP(A3*1.75,0)-0.01
But I want it to not go to the higher amount and stay just to the nearest 9.
Thank you for your suggestions,
Justin
1 Reply
Sort By
- Riny_van_EekelenPlatinum Contributor