Introduction CEILING.PRECISE 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, READ MORE

# Tag: Math and trigonometry

## How to use Excel CEILING.MATH function

Introduction CEILING.MATH function in excel is a Math/Trig function. It is a worksheet function. It rounds up the given function to a defined multiple. For example, number 1.5 is rounded up to nearest multiple of 1 by formula =CEILING.MATH(1.5,1) which gives 2 as the result. CEILING.MATH function is different from CEILING as it uses 1 as a default multiple and READ MORE

## How to use Excel FLOOR.MATH function

Introduction FLOOR.MATH function in excel is a Math/Trig function. It is a worksheet function. It rounds down the given function to a defined multiple. For example, number 1.5 is rounded down to nearest multiple of 1 by formula =FLOOR.MATH(1.5,1) which gives 1 as the result. FLOOR.MATH function is different from FLOOR as it uses 1 as a default multiple and READ MORE

## 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, READ MORE

## How to use Excel INT function

Introduction INT function in excel is a Math/Trig function. It is a worksheet function. It rounds down the given decimal number to the nearest integer part. For example, number 2.8 is rounded down to the nearest integer by using the formula =INT(2.8) which gives 2 as the result. Syntax =INT(Number) Arguments Number- The number or cell containing the number that READ MORE

## How to use Excel MROUND function

Introduction MROUND function in excel is a Math/Trig function. It is a worksheet function. It rounds up or down the given function to a defined multiple. For example, number 8.5 is rounded to nearest multiple of 3 by formula =MROUND(8.5,3) which gives 9 as the result. Syntax =MROUND(Number, Multiple) Arguments Number- The number or cell containing the number that is READ MORE

## How to use Excel ROUNDDOWN function

Introduction ROUNDDOWN function in excel is a Math/Trig function. It is a worksheet function. It rounds down the given function to a defined number of decimal places. For example, number 1.5 is rounded down to 0 decimal places by formula =ROUNDDOWN(1.5,0) which gives 1 as the result. ROUNDDOWN function is same as MROUND function except it always rounds down. Syntax READ MORE

## How to use Excel ODD function

Introduction ODD function in excel is a Math/Trig function. It is a worksheet function. It rounds up the given function to the nearest odd integer. For example, number 2 is rounded up to the nearest odd integer by using the formula =ODD(2) which gives 3 as the result. It can also be used to find the number of items which READ MORE

## How to use Excel ROUNDUP function

Introduction ROUNDUP function in excel is a Math/Trig function. It is a worksheet function. It rounds up the given function to a defined number of decimal places. For example, number 1.5 is rounded up to 0 decimal places by formula =ROUNDUP(1.5,0) which gives 2 as the result. ROUNDUP function is same as MROUND function except it always rounds up. Syntax READ MORE

## How to use Excel CEILING function

Introduction Ceiling function in excel is a Math/Trig function. It is a worksheet function. It rounds up the given function to a defined multiple. For example, number 1.5 is rounded up to nearest multiple of 1 by formula =CEILING(1.5,1) which gives 2 as the result. Ceiling function is same as MROUND function except it always rounds up. Syntax =CEILING(Number, Multiple) READ MORE