Round values to 0.05 or 0.00

  • Thread starter Thread starter Richard Hope
  • Start date Start date
R

Richard Hope

On an Excel spreadsheet, I'm looking to convert prices (or
numbers with 2 decimal places) to the nearest .00 or .05 -
for example £1.42 would round down to £1.40, £1.44 would
round up to £1.45. I can see how to round up or down
to .00, but not to a mid-range .05. Is this possible? Help
much appreciated!

Thanks in anticipation,

Richard H.
 
Take a look at the MROUND() function.

/i.

On an Excel spreadsheet, I'm looking to convert prices (or
numbers with 2 decimal places) to the nearest .00 or .05 -
for example £1.42 would round down to £1.40, £1.44 would
round up to £1.45. I can see how to round up or down
to .00, but not to a mid-range .05. Is this possible? Help
much appreciated!

Thanks in anticipation,

Richard H.
 
=MROUND(A1,.05)

On an Excel spreadsheet, I'm looking to convert prices (or
numbers with 2 decimal places) to the nearest .00 or .05 -
for example £1.42 would round down to £1.40, £1.44 would
round up to £1.45. I can see how to round up or down
to .00, but not to a mid-range .05. Is this possible? Help
much appreciated!

Thanks in anticipation,

Richard H.
 
One way

=ROUND(A1/0.05,0)*0.05

no need for ATP functions

--

Regards,

Peo Sjoblom


On an Excel spreadsheet, I'm looking to convert prices (or
numbers with 2 decimal places) to the nearest .00 or .05 -
for example £1.42 would round down to £1.40, £1.44 would
round up to £1.45. I can see how to round up or down
to .00, but not to a mid-range .05. Is this possible? Help
much appreciated!

Thanks in anticipation,

Richard H.
 
Back
Top