Rounding to 1/4 cent

jberry216 · Mar 5th, 2002, 09:58 AM

I wish to round linked volumes to the nearest .0025. Help please.

Steve Hartman · Mar 5th, 2002, 10:10 AM

=MROUND(A1,.0025)

This requires the analysis tool pack

Mar 5th, 2002, 10:15 AM

Can you make do with the Ceiling function.

i.e. =CEILING(A1,0.0025) ???

Steve Hartman · Mar 5th, 2002, 10:17 AM

Ceiling only rounds UP, not to the nearest.

jberry216 · Mar 5th, 2002, 10:37 AM

The MROUND tack returns a #NUM! error

Steve Hartman · Mar 5th, 2002, 10:47 AM

Do you have the analysis ToolPack installed?

jberry216 · Mar 5th, 2002, 10:55 AM

Fixed. Note: If the number being evaluated is less than 0, you must put a -.0025

Argument works thusly:

=IF(A1<0,MROUND(A1,-.0025),MROUND(A1,.0025))

Thanks for the help.

Steve Hartman · Mar 5th, 2002, 10:58 AM

Thank YOU! I didn't know that and I didn't even consider negative numbers.

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

Mar 5th, 2002, 09:58 AM	#1
jberry216 New Member Join Date: Feb 2002 Location: Houston, TX Posts: 14	I wish to round linked volumes to the nearest .0025. Help please.

Mar 5th, 2002, 10:10 AM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	=MROUND(A1,.0025) This requires the analysis tool pack

Mar 5th, 2002, 10:15 AM	#3
Guest Posts: n/a	Can you make do with the Ceiling function. i.e. =CEILING(A1,0.0025) ???

Mar 5th, 2002, 10:17 AM	#4
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Ceiling only rounds UP, not to the nearest.

Mar 5th, 2002, 10:37 AM	#5
jberry216 New Member Join Date: Feb 2002 Location: Houston, TX Posts: 14	The MROUND tack returns a #NUM! error

Mar 5th, 2002, 10:47 AM	#6
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Do you have the analysis ToolPack installed?

Mar 5th, 2002, 10:55 AM	#7
jberry216 New Member Join Date: Feb 2002 Location: Houston, TX Posts: 14	Fixed. Note: If the number being evaluated is less than 0, you must put a -.0025 Argument works thusly: =IF(A1<0,MROUND(A1,-.0025),MROUND(A1,.0025)) Thanks for the help.

Mar 5th, 2002, 10:58 AM	#8
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Thank YOU! I didn't know that and I didn't even consider negative numbers.