Rounding Formula - Excel

  • Thread starter Thread starter Denise
  • Start date Start date
D

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.
 
Denise,

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

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

=MROUND(C7,0.5)

Dan E
 
Back
Top