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, 200817 yr by Guest

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

Edited August 1, 200817 yr by Guest
Fixed my math.