Round Up in Excel

Occasional Visitor

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

@Justin928 Round up to 1 digit first, then subtract 0.01, like this:

=ROUNDUP(B3*1.75,1)-0.01