Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rounding up and down formula
I recently contributed to this thread and posted a link (on web site) to a
working (Excel) demonstration which subsequently proved to be inaccurate. I said then I would try to get it right so I have given it another go The result at www.1001solutions.co.uk/rounding.xls is even more confusion. I have found (so far unexplained) inconsistencies both within and between the ceiling / floor and the roundup / rounddown methods which, perhaps, Sandy Mann or Macropod (who kindly responded to my last effort) may be able to explain. Thanks. Bill Ridgeway |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rounding up and down formula
Hi Bill,
I think you expect the 2nd argument to behave the same for ROUND and FLOOR. But that is not the case. One rounds to multiples of that argument, the other round to the specified number of digits (fractions working the other way around). MROUND() works more like FLOOR and CEILING. -- Kind regards, Niek Otten Microsoft MVP - Excel "Bill Ridgeway" wrote in message ... |I recently contributed to this thread and posted a link (on web site) to a | working (Excel) demonstration which subsequently proved to be inaccurate. I | said then I would try to get it right so I have given it another go The | result at www.1001solutions.co.uk/rounding.xls is even more confusion. I | have found (so far unexplained) inconsistencies both within and between the | ceiling / floor and the roundup / rounddown methods which, perhaps, Sandy | Mann or Macropod (who kindly responded to my last effort) may be able to | explain. | | Thanks. | | Bill Ridgeway | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding up and or down formula | New Users to Excel | |||
Formula Rounding | Excel Worksheet Functions | |||
Rounding Formula | Excel Worksheet Functions | |||
Rounding up Formula | Excel Worksheet Functions | |||
rounding a formula with sum | Excel Discussion (Misc queries) |