How to use Excel CEILING.PRECISE function

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

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