| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding a group of numbers
In an excel file, I have a workout based on percentages and numbers.
Therefore for each cell, there is a forumla like this =D$70*(1-3*$B$49), except with different numbers for every cell. That forumla comes up with the number 62. I want to round every number to a multiple of 5. What formula can I add to every cell that will do this. I know the formula, =mround x number, 5, which rounds number x to a multiple of 5 How can I apply that to a large number of cells? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop numbers from rounding in Excel? | Excel Discussion (Misc queries) | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| How can I sort a group of numbers automatically as data is entere | Excel Worksheet Functions | |||
| rounding numbers, with-out decimals. IE:4507 to 4510 | Excel Worksheet Functions | |||
| Rounding Numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
