Select theFormulas tabof theribbon.
Select on theMath & Trigicon to initiate the function drop-down.
SelectMROUNDin the list to open theFunction Dialog Box.
SelectcellA2in the worksheet to enter this cell reference as the number argument.
SelectDoneto return to the worksheet.
The value4.55should appear incellC2since it is the nearest multiple of 0.05 larger than 4.54.
When you selectcellC2, the complete function will appear in theformulabarabove the worksheet.
Multiple(required) is the multiple to which you want to round thenumber.
