Round Problems
 

We are working on our catalog price sheet. We have figures as follows:

$152.50 $161.75 $158.00
$157.00

I want the numbers to round up or down to the closest $5.00.

$152.50 = $155.00
$161.75 = $160.00
$158.00 = $160.00
$157.00 = $155.00

Is this possible? I have tried using the round, ceiling, floor feature.
Either it doesn't go both ways or I am not getting the write amount.

Thank you for your time.

Angela

Round Problems
 

maybe:

=ROUND(x/5,0)*5

"Angela" wrote:

We are working on our catalog price sheet. We have figures as follows:

$152.50 $161.75 $158.00
$157.00

I want the numbers to round up or down to the closest $5.00.

$152.50 = $155.00
$161.75 = $160.00
$158.00 = $160.00
$157.00 = $155.00

Is this possible? I have tried using the round, ceiling, floor feature.
Either it doesn't go both ways or I am not getting the write amount.

Thank you for your time.

Angela

Round Problems
 

=MROUND(A1,5)

Vaya con Dios,
Chuck, CABGx3




"Angela" wrote:

We are working on our catalog price sheet. We have figures as follows:

$152.50 $161.75 $158.00
$157.00

I want the numbers to round up or down to the closest $5.00.

$152.50 = $155.00
$161.75 = $160.00
$158.00 = $160.00
$157.00 = $155.00

Is this possible? I have tried using the round, ceiling, floor feature.
Either it doesn't go both ways or I am not getting the write amount.

Thank you for your time.

Angela