I need to round a cell to the nearest five dollars.

Example

$43.25 would down to $43.00
$43.75 would round up to $45.00

Can anyone help?

With Analysis Toolpak:
=MROUND(A1,5)

Without ATP:
=FLOOR(A1,5)+(A1-FLOOR(A1,5)2.5)*5

HTH
Kostis Vezerides

John wrote:
I need to round a cell to the nearest five dollars.

Example

$43.25 would down to $43.00
$43.75 would round up to $45.00

Can anyone help?

Hi John...........

Your sample data appears inconsistant with your stated desire.

Please clarify.

Vaya con Dios,
Chuck, CABGx3



"John" wrote:

I need to round a cell to the nearest five dollars.

Example

$43.25 would down to $43.00
$43.75 would round up to $45.00

Can anyone help?