rounding to nearest 5

[wilson35]

How do you round an answer to the nearest five, 0 or 5

 

[rrdonutz]

=MROUND(number, 5)

Others exist; you'll get plenty of other responses . . .

(note from Excel: If this function is not available on your machine, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.)

 

[Aladin Akyurek]

How do you round an answer to the nearest five, 0 or 5

=ROUND(A1/5,0)*5

 

[phantom1975]

Try this:

=ROUND(A1/5,0)*5

 

[Mark W.]

=FLOOR(A1,5)