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

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" <[email protected]>
wrote in message
news:[email protected]...
>
> With your price in A1
>
> =ROUND(A1-1,-1)-1
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile:
> http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=511418
>

On Sat, 11 Feb 2006 19:40:55 -0600, ktexcel
<[email protected]> 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


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


--ron

On Sat, 11 Feb 2006 18:18:58 -0800, "Peo Sjoblom" <[email protected]> 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