| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with round down
I want to round a number down to three decimal places and have tried
rounddown, floor and trunc but I keep getting an unintended result in the following situation: If my number is 0.3021 i want to return 0.302 If my number is 0.3027 i want to return 0.302 If my number is 0.3020 i want to return 0.302, but I keep getting 0.301 All of these give me 0.301 when the fourth decimal place is a zero. ROUNDOWN(cell,3) FLOOR(cell,0.001) TRUNC(cell,3) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| round up #.#0 and #.#5 | New Users to Excel | |||
| Round() problem | Excel Worksheet Functions | |||
| Don't Round... | Excel Discussion (Misc queries) | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
| How can i round off .10 as .50 and .51 as 1.00 | Excel Worksheet Functions | |||
Threaded Mode
