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 … 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 … 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 … 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 … Read more