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

MROUND

The MROUND function rounds a number to the nearest multiple of a specified factor. If the number to be rounded is halfway between two multiples then MROUND rounds away from 0. Both arguments are number values.

MROUND(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

=MROUND(2, 3) returns 3, the multiple of 3 nearest to 2.

=MROUND(4, 3) returns 3, the multiple of 3 nearest to 4.

=MROUND(4.4999, 3) returns 3, the multiple of 3 nearest to 4.4999.

=MROUND(4.5, 3) returns 6, the multiple of 3 nearest to 4.5.

=MROUND(–4.4999, –3) returns –3, the multiple of –3 nearest to –4.4999.

=MROUND(–4.5, -3) returns –6, the multiple of –3 nearest to –4.5.

=MROUND(–4.5, 3) returns an error, as both arguments must be positive or negative.

See alsoCEILINGEVENFLOORINTODDROUNDROUNDDOWNROUNDUPTRUNC
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.