Problems with MROUND

lowelit

New member
Joined
Feb 6, 2014
Messages
2
Reaction score
0
Points
0
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
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Try

=MROUND(your_formula,5)

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

lowelit

New member
Joined
Feb 6, 2014
Messages
2
Reaction score
0
Points
0
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!
 
Top