Round to multiple of 5
 

I am having trouble with formula to round results to a multiple of 5

Current formula results return the following values and I want to round them
to the nearest multiple of .05

Current Desired
Result Result
$25.61 = $25.60
$25.83 = $25.85
$26.06 = $26.05
$26.28 = $26.30
$26.50 = $26.50
$26.72 =$ 26.70

Appreciate any help. Thank you

Round to multiple of 5
 

=MROUND(A1,0.05)

If you get a #NAME error:

ToolsAdd-Ins, check Analysis Toolpak

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JmyCrikitt" wrote in message ...
|I am having trouble with formula to round results to a multiple of 5
|
| Current formula results return the following values and I want to round them
| to the nearest multiple of .05
|
| Current Desired
| Result Result
| $25.61 = $25.60
| $25.83 = $25.85
| $26.06 = $26.05
| $26.28 = $26.30
| $26.50 = $26.50
| $26.72 =$ 26.70
|
| Appreciate any help. Thank you
|
|

Round to multiple of 5
 

with you number in a1 maybe this

=ROUND(A1/0.05,0)*0.05

Mike

"JmyCrikitt" wrote:

I am having trouble with formula to round results to a multiple of 5

Current formula results return the following values and I want to round them
to the nearest multiple of .05

Current Desired
Result Result
$25.61 = $25.60
$25.83 = $25.85
$26.06 = $26.05
$26.28 = $26.30
$26.50 = $26.50
$26.72 =$ 26.70

Appreciate any help. Thank you

Round to multiple of 5
 

On Thu, 28 Feb 2008 12:28:06 -0800, JmyCrikitt
wrote:

I am having trouble with formula to round results to a multiple of 5

Current formula results return the following values and I want to round them
to the nearest multiple of .05

Current Desired
Result Result
$25.61 = $25.60
$25.83 = $25.85
$26.06 = $26.05
$26.28 = $26.30
$26.50 = $26.50
$26.72 =$ 26.70

Appreciate any help. Thank you



=ROUND(A1/0.05,0)*0.05

--ron