I'm trying to take a number add 10% and then round up to the nearst 10th

Options

Example the number is 74 so I want to add 10% and then round up so my total would be 90

74*10% = 7.4

74+7.4 = 81.4

Roundup to 90

I'm using =MROUND(ROUNDUP([Estimated number of participants]@row * 0.1) + ([Estimated number of participants]@row), 10)

but its returning 80. Formulas are not my strong suite and guess how to rewrite this?

Best Answer

  • Ryan Sides
    Ryan Sides ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi Connie, is this what you're looking for?

    =ROUNDUP([Estimated number of participants]@row * 1.1 / 10) * 10

    It takes your number, adds 10%, then divides that by 10. Then rounds up the nearest integer and multiplies that by 100.

    = 74

    = 74+7.4 = 81.4

    = 8.14

    = 9

    =9*10 = 90

    Ryan Sides

    Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

    Come Say Hello!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!