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
Click to expand...


=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

Similar Threads

How to round down a value to the inferior multiple of 5 3
Help with formula to round up to next higher multiple of 5 3
How do I round a formula result to the next integer? 8
ROUND to nearest 5 4
in access, round up to nearest fraction(.5) 1
Excell, changing wholesale to retail, round up to multipuls $5 2
How do I round numbers to the nearest multiple of 10 or 5? 4
Round up to nearest multiple of 5 3

Top