Round Up in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1727305%22%20slang%3D%22en-US%22%3ERound%20Up%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1727305%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20I%20need%20help%20with%20a%20formula%20to%20round%20up%20to%20the%20nearest%209.%20My%20goal%20is%20to%20use%20Excel%20for%20markups%2Fpricing.%20For%20example%20%241.23%20*%201.72%25%20%3D%20%242.12.%20I%20want%20to%20round%20to%20the%20nearest%209%2C%20from%202.12%20to%202.19.%20I%20have%20used%20the%20round%20up%20function%20and%20was%20able%20to%20go%20to%20%242.99%2C%26nbsp%3B%20%3CSTRONG%3E%3DROUNDUP(A3*1.75%2C0)-0.01%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EBut%20I%20want%20it%20to%20%3CU%3Enot%3C%2FU%3E%20go%20to%20the%20higher%20amount%20and%20stay%20just%20to%20the%20nearest%209.%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20suggestions%2C%3C%2FP%3E%3CP%3EJustin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1727305%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1727465%22%20slang%3D%22en-US%22%3ERe%3A%20Round%20Up%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1727465%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F814233%22%20target%3D%22_blank%22%3E%40Justin928%3C%2FA%3E%26nbsp%3BRound%20up%20to%201%20digit%20first%2C%20then%20subtract%200.01%2C%20like%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DROUNDUP(B3*1.75%2C1)-0.01%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted

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

=ROUNDUP(B3*1.75,1)-0.01