## How to use Excel FLOOR function

Introduction FLOOR function in excel is a Math/Trig function. It is a worksheet function. It rounds down the given number to the nearest multiple , towards zero. For example, number 1.5 is rounded down by significance 1 to the nearest integer towards zero by formula =FLOOR(1.5,1) which gives 1 as the result. FLOOR function is same as MROUND function except it always rounds down. Syntax =FLOOR(Number, Significance) Arguments Number- The number or cell containing the number that is to be…