Justin928Copper ContributorSep 30, 2020Round 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...Show More
Riny_van_EekelenPlatinum ContributorSep 30, 2020Justin928 Round up to 1 digit first, then subtract 0.01, like this:=ROUNDUP(B3*1.75,1)-0.01
