Problems with MROUND

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

Try

=MROUND(your_formula,5)

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

NBVC said:

Try

=MROUND(your_formula,5)

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

Click to expand...

It worked perfectly, thank you very much!