Retail prices end in 9!

[ktexcel]

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

 

[daddylonglegs]

With your price in A1

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

 

[Peo Sjoblom]

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]...

 

[Ron Rosenfeld]

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

 

[Ron Rosenfeld]

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