Formulas and Functions
এই নিয়ন্ত্রণ পরিবর্তন করলে এই পেজটি স্বয়ংক্রিয়ভাবে আপডেট হবে

CEILING

The CEILING function rounds a number away from 0 to the nearest multiple of the specified factor. Both arguments are number values.

CEILING(num-to-round, multiple-factor)

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

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

Examples

=CEILING(0.25, 1) returns 1, the nearest multiple of 1 that is greater than or equal to 0.25.

=CEILING(1.25, 1) returns 2, the nearest multiple of 1 that is greater than or equal to 1.25.

=CEILING(–1.25, –1) returns –2, the nearest multiple of 1 that is a greater negative value than –1.25.

=CEILING(5, 2) returns 6, the nearest multiple of 2 that is greater than 5.

=CEILING(73, 10) returns 80, the nearest multiple of 10 that is greater than 73.

=CEILING(7, 2.5) returns 7.5, the nearest multiple of 2.5 that is greater than 7.

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