MROUND() FUNCTION

Question

Hi Team,&nbsp;I frequently use MROUND() with each cell . Each time when I need to use the function for different numbers I need to write Mround for each of the numbers. for eg : the following numbers should be Mrounded with the multiple of 5&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 155.00&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 130.00&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120.00&nbsp;How will I apply Mround for all of them without writing mround() each time for each cell.&nbsp;Request to please help me in this regard.

haytham amairah · Accepted Answer

Hi Aamir,&nbsp;You don't have to rewrite the formula for each cell!Just use the Fill Handle to copy the formula in any direction as the below gif.

Forum Discussion

MROUND() FUNCTION

Share

Resources