TOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/p>\n
What this Formula does ?<\/h3>\n
Basically FLOOR<\/strong> returns the nearest multiple significance number towards Zero. The multiple significance is defined by user while writing this formula.
\n
\nSyntax:<\/strong><\/p>\nFLOOR(number,significance) <\/span>
\n
\nWhere:
\nNumber:<\/strong> is the Number for which you want the nearest significance.
\nSignificance:<\/strong> is the multiple to which you want to round off.<\/p>\n <\/p>\n
Remarks:<\/h3>\n
1.<\/strong> If any of the arguement is nonnumeric then formula will return #VALUE Error.
\n
\n2.<\/strong> Sign of the number is not taken in to the consideration. It mean no matter whihc sign the number has, it will rounded off to the nearest multiple of significance. But for both the argument sign must be same. Refer example row number – 6.
\n
\n3.<\/strong> If Number and Significance have different signs then formula will return #NUM! Error. Refer below example row number – 5
\n<\/p>\nExample:<\/h3>\n
<\/p>\n
\n
\n\n Number <\/th>\n | Rounded Value <\/th>\n | Formula used to get Rounded Value <\/th>\n<\/tr>\n |
\n1.5<\/td>\n | 3<\/td>\n | =FLOOR(A1,1)<\/font><\/td>\n<\/tr>\n\n2.3<\/td>\n | 2<\/td>\n | =FLOOR(A2,1)<\/font><\/td>\n<\/tr>\n\n2.9<\/td>\n | 2<\/td>\n | =FLOOR(A3,2)<\/font><\/td>\n<\/tr>\n\n199<\/td>\n | 150<\/td>\n | =FLOOR(A4,50)<\/font><\/td>\n<\/tr>\n\n-40<\/td>\n | #NUM!<\/td>\n | =FLOOR(A5,30)<\/font><\/td>\n<\/tr>\n\n-190<\/td>\n | -150<\/td>\n | =FLOOR(A5,-50)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n <\/p>\n Difference between FLOOR()<\/strong> and CIELING()<\/strong>:<\/h3>\nBoth the above functions do the nearest multiple of the significance. The difference is that CIELING() round to the Next<\/strong> multiple of the significance while FLOOR() to the Previous<\/strong> multiple of the significance.<\/p>\n<\/a><\/p>\n | | | | | |