Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with sum up or down in cells
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 |
#2
|
|||
|
|||
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... "Kim Kappel" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |