Rounding Formula - Excel

[Denise]

Does anyone know how to build a formula that rounds
numbers to the nearest $.50? For example: If the number
was $42.26 it would round to $42.50, but if it were $42.24
it would round to $42.00.

 

[Dan E]

Denise,

=ROUND(C7*1/50,2)*50

Or if you have the analysis toolpack installed (Tools ->
Add-ins)

=MROUND(C7,0.5)

Dan E