Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
One cell in an Excell spreadsheet contains a mathematical formula and the
answer is always a decimal out to at least 6 places. I need to program that cell so that it will round as follows: If the 6th decimal place number is 5 or less, round down to 5 decimal places. If the 6th place number is 6 or more, round up to 5 decimal places. Here's an example. Let's say the formual results in .005395833. I need it to round to .00539. However, if the formula results in .00626639, I need it to round to .00627 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Rounding in Excel | Excel Discussion (Misc queries) | |||
rounding in excel | Excel Discussion (Misc queries) | |||
Rounding in Excel | Excel Discussion (Misc queries) |