How to use Excel ISO.CEILING function

Introduction

ISO.CEILING function in excel is a Math/Trig function. It is a worksheet function. It rounds up the given function to a defined multiple or the nearest integer. It is different from CEILING function in the sense that whatever may be the sign of the number, it always rounds up. By default it uses 1 as a multiple. For example, number 1.5 is rounded up to nearest multiple of 1 by formula =ISO.CEILING(1.5,1) which gives 2 as the result.

Syntax

=ISO.CEILING(Number, Multiple)

Arguments

  • Number- The number or cell containing the number that is to be rounded off.
  • Multiple- It is the multiple to which you can round up the number

Keynotes

  • If the provided number is a multiple of multiple argument, it is not rounded up.
  • If argument is non numeric, #VALUE! error is displayed.
  • By default it uses 1 as a multiple.
  • It is different from CEILING function in the sense that whatever may be the sign of the number, it always rounds up and negative numbers are rounded towards zero.
  • If the number or multiple used has value 0 then zero is retrieved as the result.
  • This function was introduced in Excel 2010 and thus not available in older versions.

Examples

In the following example, a table of numbers is given, it is rounded up using ISO.CEILING function.

In the following example, number of items and their bundle size is given; we use ISO.CEILING function to find how many bundles are needed.

Leave a Reply

Your email address will not be published. Required fields are marked *