Is there a formula I can use to round numbers up or down to

alexb · Mar 21st, 2002, 05:38 AM

I need to round all numbers in a column to the nearest 5 ie 1932 becomes 1930 and 1993 becomes 1995?

thank you

Steve Hartman · Mar 21st, 2002, 05:41 AM

=MROUND()

Requires you have the Analysis ToolPak installed.

Aladin Akyurek · Mar 21st, 2002, 05:41 AM

Quote:

On 2002-03-21 04:38, alexb wrote:
I need to round all numbers in a column to the nearest 5 ie 1932 becomes 1930 and 1993 becomes 1995?

thank you

Try:

=ROUND(A1/5,0)*5

or

=MROUND(A1,5)

The latter requires the Analysis Toolpak (available via Tools|Add-Ins)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 05:38 AM	#1
alexb New Member Join Date: Mar 2002 Posts: 17	I need to round all numbers in a column to the nearest 5 ie 1932 becomes 1930 and 1993 becomes 1995? thank you

Mar 21st, 2002, 05:41 AM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	=MROUND() Requires you have the Analysis ToolPak installed.