Round to multiple of 5

J

JmyCrikitt

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
 
N

Niek Otten

=MROUND(A1,0.05)

If you get a #NAME error:

Tools>Add-Ins, check Analysis Toolpak

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
|
|
 
R

Ron Rosenfeld

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top