Need to round a formula up or down to a specific number
 

I am working a retail price formula rounding up or down to either

$X,X49.95
$X,X99.95

Need to round a formula up or down to a specific number
 

=ROUND(D4,0)

this will round to the nearest dollar, up or down


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519046

Need to round a formula up or down to a specific number
 

With your price in A1 try

=ROUND((A1+0.05)*2,-2)/2-0.05

or using MROUND from Analysis ToolPak

=MROUND(A1+0.05,50)-0.05


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=519046

Need to round a formula up or down to a specific number
 

Try one of these:

For a value in A1,

B1: =ROUND(A1/50,0)*50-0.05
or
B1: =MROUND(A1,50)-0.05
(MROUND is from the Analysis Toolpak)

Note: the lowest price that works for is $25.00. Under that, the formula
calculates $-0.05. If you want the minimum price to be $49.95, try one of
these:

B1: =ROUND(MAX(A1,25)/50,0)*50-0.05
or
B1: =MROUND(MAX(A1,25),50)-0.05

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Eric Foucrier" wrote:

I am working a retail price formula rounding up or down to either

$X,X49.95
$X,X99.95

Need to round a formula up or down to a specific number
 

davesexcel Wrote:
=ROUND(D4,0)

this will round to the nearest dollar, up or down

OOPS! read the question wrong


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519046