Help with sum up or down in cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.

I need help for the following:

I need to sum up or down the value of a cell to the nearest 5 or 10

If a cell shows 1 it must be corrected to 0
If a cell shows 7 it must be corrected to 5
If a cell shows 8 it must be corrected to 10
If a cell shows 21 it must be corrected to 20
If a cell shows 23 it must be corrected to 25

BR Kim
 
Hi,

The MROUND() function available after installing Analysis Toolpak allows you
to define the rounding multiple. So if in A1 you have 4, the =MROUND(A1,5) =
5...

Tools->Addins->Analysis Toolpak to install...
 
You must log in or register to reply here.

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

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Copying formulas - problem with the sum 1
Numbers showing Up Centered in Cell ? 1
Count/Sum rows of a column depending on criteria from drop-down li 4
Modifying a complex date formual to count months 4
formula to make the value in a cell, to a row in a sum function 5
Excel Typed text appears in wrong cell 0
Calculation / Format Error 1

Back
Top