Round values to 0.05 or 0.00

[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.

 

[Immanuel]

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.

 

[Jesse]

=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.

 

[Peo Sjoblom]

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.