Sep 29 2020 07:48 PM
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
Sep 29 2020 09:59 PM