Retail prices end in 9!

Hello,

I have a list of calculated prices for retail articles that I need "
rounded" up or down to the nearest number ending in 9.
eg 411.54 would round to 409$ and 356.24 rounds to 359$
How to do??
K:confused:


--
ktexcel
------------------------------------------------------------------------
ktexcel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31456
View this thread: http://www.excelforum.com/showthread.php?threadid=511418

daddylonglegs
Sat Feb 11 19:46:52 CST 2006


With your price in A1

=ROUND(A1-1,-1)-1


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30486
View this thread: http://www.excelforum.com/showthread.php?threadid=511418

Peo
Sat Feb 11 20:18:58 CST 2006

Maybe this change to your formula

=ROUND(A1,-1)-1

otherwise it will display 249 if the value is 255



--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"daddylonglegs" <daddylonglegs.233fha_1139709001.0872@excelforum-nospam.com>
wrote in message
news:daddylonglegs.233fha_1139709001.0872@excelforum-nospam.com...
>
> With your price in A1
>
> =ROUND(A1-1,-1)-1
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=30486
> View this thread: http://www.excelforum.com/showthread.php?threadid=511418
>

Ron
Sat Feb 11 21:06:21 CST 2006

On Sat, 11 Feb 2006 19:40:55 -0600, ktexcel
<ktexcel.233f8y_1139708700.9639@excelforum-nospam.com> wrote:

>
>Hello,
>
>I have a list of calculated prices for retail articles that I need "
>rounded" up or down to the nearest number ending in 9.
>eg 411.54 would round to 409$ and 356.24 rounds to 359$
>How to do??
>K:confused:


=ROUND(A1+1,-1)-1


--ron

Ron
Sat Feb 11 21:13:18 CST 2006

On Sat, 11 Feb 2006 18:18:58 -0800, "Peo Sjoblom" <terre08@mvps.org> wrote:

>Maybe this change to your formula
>
>=ROUND(A1,-1)-1
>
>otherwise it will display 249 if the value is 255

Hmmm

The nearest number ending in nine.

254 - 249 = 5
254.01 - 249 = 5.01
259 - 254.01 = 4.99

So 254.01 should round to 259.

Your formula rounds it to 249.

I think:

=ROUND(A1+1,-1)-1



--ron