Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick question, just for interest...
What's the difference between Floor and Rounddown? Looking at the function help guide there doesn't seem to be any... Many thanks, Chris -- Tibbs ------------------------------------------------------------------------ Tibbs's Profile: http://www.excelforum.com/member.php...o&userid=15947 View this thread: http://www.excelforum.com/showthread...hreadid=520996 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick question, just for interest...
ROUNDDOWN only rounds to a decimal place or a power of ten (down to nearest
1, 10, 100, .1,01, etc.), whereas as FLOOR sets it down to the nearest value, which can be a decimal place or power of 10 like ROUNDOWN, or any other value. So =ROUNDDOWN(223,-2) is the same as =FLOOR(223,100) but there is no direct equivalent of say =FLOOR(223,110) You can get it with =ROUNDDOWN(223/110,1)*110 but I know which I prefer -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Tibbs" wrote in message ... What's the difference between Floor and Rounddown? Looking at the function help guide there doesn't seem to be any... Many thanks, Chris -- Tibbs ------------------------------------------------------------------------ Tibbs's Profile: http://www.excelforum.com/member.php...o&userid=15947 View this thread: http://www.excelforum.com/showthread...hreadid=520996 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick question, just for interest...
Thanks for that, my curiosity has been assuaged! Chris -- Tibbs ------------------------------------------------------------------------ Tibbs's Profile: http://www.excelforum.com/member.php...o&userid=15947 View this thread: http://www.excelforum.com/showthread...hreadid=520996 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quick Macro question - How to delete two rows then skip one - and repeat | Excel Discussion (Misc queries) | |||
Quick Question - Pivot Table Data | Excel Discussion (Misc queries) | |||
quick charting question for similar charts on multiple sheets | Charts and Charting in Excel | |||
Excel Colours - Quick Question | Excel Discussion (Misc queries) | |||
Quick formula question | Excel Worksheet Functions |