Round down?

[JRae]

Hello,

I am creating an Estimating worksheet for Marketing personnel. They would like for the final cost to be rounded up or down according to the price. I know how to round up, but is there a way to round down? So if the cost is $653.00 it will round down to $650.00.

Thanks

Edited July 31, 2008 by Guest

[The Shadow]

Round( price, -1 ) will round 653 down to 650, and 655 up to 660.

Edited August 1, 2008 by Guest
Fixed my math.