Formula to round to the nearest $50

LJONES · May 17th, 2002, 09:01 AM

I'm looking for a formula to round to the nearest $50. Can you help?

Thanks!

Ricky Morris · May 17th, 2002, 09:08 AM

Try:

=Floor(A1,50) to round down to nearest 50.
or
=Ceiling(A1,50) to round up to nearest 50.

Dave Patton · May 17th, 2002, 09:08 AM

[quote]
On 2002-05-17 08:01, LJONES wrote:
I'm looking for a formula to round to the nearest $50. Can you help?

try

=ROUND(E3/50,0)*50

How do you want to round say $15, the above will round to 0.

Yogi Anand · May 17th, 2002, 09:44 AM

or you may use the MROUND function:

=MROUND(A1,50)

MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.
If this function is not available, 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.

May 17th, 2002, 09:08 AM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Try: =Floor(A1,50) to round down to nearest 50. or =Ceiling(A1,50) to round up to nearest 50. __________________ It's never too late to learn something new. Ricky

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

May 17th, 2002, 09:01 AM	#1
LJONES New Member Join Date: May 2002 Location: Bloomington, IL Posts: 2	I'm looking for a formula to round to the nearest $50. Can you help? Thanks!

May 17th, 2002, 09:08 AM	#3
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	[quote] On 2002-05-17 08:01, LJONES wrote: I'm looking for a formula to round to the nearest $50. Can you help? try =ROUND(E3/50,0)*50 How do you want to round say $15, the above will round to 0.

May 17th, 2002, 09:44 AM	#4
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	or you may use the MROUND function: =MROUND(A1,50) MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple. If this function is not available, 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.