| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
round a 15 digit decimal down from .05
What code to use to round a 15 digit decimal down if it's less than .05 and
up if it's over that in EXCEL. My work does calculations in grams. Also, need to know how to divide the above number by 100 to get a per cent of total weight . I'm tending to want to use MOD, MROUND and INTEGER. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
round a 15 digit decimal down from .05
In Excel
=ROUND(x,1) or in VBA Application.Round(x,1) Jerry Excell-ent wrote: What code to use to round a 15 digit decimal down if it's less than .05 and up if it's over that in EXCEL. My work does calculations in grams. Also, need to know how to divide the above number by 100 to get a per cent of total weight . I'm tending to want to use MOD, MROUND and INTEGER. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
round a 15 digit decimal down from .05
I'll try it and get back to you. Thanks. What about the cell that makes a
percent from dividing two cells of the grams with 15 digits - please answer in both Excel and VBA. "Jerry W. Lewis" wrote: In Excel =ROUND(x,1) or in VBA Application.Round(x,1) Jerry Excell-ent wrote: What code to use to round a 15 digit decimal down if it's less than .05 and up if it's over that in EXCEL. My work does calculations in grams. Also, need to know how to divide the above number by 100 to get a per cent of total weight . I'm tending to want to use MOD, MROUND and INTEGER. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to place a decimal after 3rd digit | Excel Discussion (Misc queries) | |||
| Format to Round to Tens Digit | Excel Discussion (Misc queries) | |||
| Round Up by a factor not by a digit [MROUNDUP(number,multiple)] | Excel Worksheet Functions | |||
| How do I stop decimal being placed in a 3 digit whole number | Setting up and Configuration of Excel | |||
| WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS | Excel Discussion (Misc queries) | |||
Linear Mode
