For a positive number and a positive meaning value, the role rounds down (towards zero). For a negative mageri and a an adverse significance value, the arah of round off is figured out by the value of a mode parameter. The duty returns an error if the sourse and significance values have actually opposite signs.

Anda sedang menonton: Cara membuat daftar isi di word 2013 secara manual



If the spreadsheet is exported to Microsoft Excel, the FLOOR duty is exported as the indistinguishable FLOOR.MATH function that has existed dari Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, usage either FLOOR.PRECISE that has existed dari Excel 2010, or FLOOR.XCL the is exported as the FLOOR role compatible v all Excel versions.


FLOOR(Number<; Significance<; Mode>>)

Number is the numberi that is to it is in rounded, or a referral to a cabinet containing the number.

Significance (optional) is the value, or a referral to a cell containing the value, to whose multiple number is to it is in rounded. That defaults come +1 or -1 relying on the tanda of Number.

Mode (optional) is a number, or a recommendation to a cell containing a number. The role only uses mode if both mageri and definition are negative. Kemudian if mode is given and not same to zero, numbers are rounded up (towards zero); if mode is same to zero or not given, an adverse numbers room rounded turun (away native zero).


=FLOOR(3.45) return 3.

=FLOOR(3.45, 3) returns 3.

=FLOOR(-1.234) return -2.

=FLOOR(-45.67, -2, 0) return -46.

=FLOOR(-45.67, -2, 1) returns -44.

FLOOR.MATH

Rounds a mageri to the nearest many of a definition value.

For a positive number the role rounds dibawah (towards zero). For a an adverse number, the direction of rounding is established by the worth of a mode parameter. The sign of the meaning value is ignored.




Significance (optional) is the value, or a recommendation to a cell containing the value, to who multiple sourse is to be rounded. That defaults to 1.

Mode (optional) is a number, or a referral to a cabinet containing a number. If setting is given and not equal to zero, a negative mageri is rounded up (towards zero). If mode is equal to zero or is not given, a negative numberi is rounded down (away native zero).


=FLOOR.MATH(3.45) return 3.

=FLOOR.MATH(3.45,-3) returns 3.

=FLOOR.MATH(-1.234) returns -2.

=FLOOR.MATH(-45.67,-2, 0) returns -46.

=FLOOR.MATH(-45.67,+2, 1) returns -44.

FLOOR.PRECISE

Rounds a number dibawah to the nearest multiple of a meaning value.

For a positive mageri the role rounds down (towards zero). Because that a negative number, the role rounds turun (away membentuk zero). The tanda of the meaning value is ignored.

Lihat lainnya: Cara Bermain Halma Dan Ludo, 4 Cara Bermain Halma Untuk Pemula




If the spreadsheet is exported come Microsoft Excel, the FLOOR function is exported together the indistinguishable FLOOR.MATH function that has existed sejak Excel 2013. If you rencana to usage the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that has existed sejak Excel 2010, or FLOOR.XCL the is exported as the FLOOR duty compatible through all Excel versions.