Results 1 to 3 of 3

Thread: Problems with MROUND

  1. #1

    Problems with MROUND



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, this is my first post at Excelguru!
    Im doing a project for my CIS Class where I have a workout schedule that is six weeks long. You put in your max in two exercises and the excel sheets calculates your percentages for each lift. My problem is that I have percentage * a cell with the max data in one column but the results is uneven. I've read about MROUND but I don't want to make a new column with the rounded numbers and it doesn't work to put it in the same formula box as the percentages calculation. I want to get the percentages calculations in 5 or 10 lbs (MROUND=(CELL, 5)

    Regards LOWELIT

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    Try

    =MROUND(your_formula,5)

    where your_formula is the current formula in the cell without the preceding = sign.


  3. #3
    Quote Originally Posted by NBVC View Post
    Try

    =MROUND(your_formula,5)

    where your_formula is the current formula in the cell without the preceding = sign.
    It worked perfectly, thank you very much!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •