Round Problems

[Angela]

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

[Duke Carey]

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

[CLR]

=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