Formulas and Functions
ਇਸ ਕੰਟਰੋਲ ਦੀ ਸੋਧ ਕਰਨ ਨਾਲ ਇਹ ਪੰਨਾ ਆਪਣੇ ਆਪ ਅੱਪਡੇਟ ਹੋ ਜਾਵੇਗਾ

FLOOR

The FLOOR function rounds a number towards 0 to the nearest multiple of the specified factor. Both arguments are number values.

FLOOR(num-to-round, factor)

num-to-round: The number to be rounded.

factor: The number to use to determine the closest multiple. factor must have the same sign as num-to-round.

Examples

=FLOOR(0.25, 1) returns 0, the nearest multiple of 1 that is less (closer to 0) than 0.25.

=FLOOR(1.25, 1) returns 1, the nearest multiple of 1 that is less than 1.25.

=FLOOR(5, 2) returns 4, the nearest multiple of 2 that is less than 5.

=FLOOR(73, 10) returns 70, the nearest multiple of 10 that is less than 73.

=FLOOR(–0.25, –1) returns 0, the nearest multiple of –1 that is greater (closer to 0) than –0.25.

=FLOOR(9, 2.5) returns 7.5, the nearest multiple of 2.5 that is less than 9.

See alsoCEILINGEVENINTMROUNDODDROUNDROUNDDOWNROUNDUPTRUNC
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
ਕੋਈ ਮਦਦ ਮਿਲੀ?
ਅੱਖਰ ਸੀਮਾ: 250
ਵੱਧ ਤੋਂ ਵੱਧ ਅੱਖਰ ਸੀਮਾ 250 ਹੈ
ਫ਼ੀਡਬੈਕ ਲਈ ਤੁਹਾਡਾ ਧੰਨਵਾਦ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.