Introduction CLEAN in excel is a text/string function. This function retrieves code from first character of a string. It retrieves Macintosh code for Mac system and ANSI system for Windows system. For example, =CODE(“B”) gives 66 as the value for Windows operating system. Syntax =CODE(Text) Arguments Text: It is the text whose first character will be used and whose code READ MORE

## How to use Excel CHAR Function

Introduction CHAR in excel is a text/string function. CHAR function is used to return a character defined by a number. In windows operating system ANSI/ASCII/Unicode character set is used. This function can be used to define characters which are complex in nature. For example =CHAR(36) returns $ character because it 36 represents $ character in windows character system. Syntax =CHAR(number) 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 IFNA function

Introduction IFNA function in excel is a logical function. This function is used in case a formula produces an error. With this one can use a customized value if an error is displayed. It checks for #N/A errors. If no error is found IFNA returns the calculated value of the formula. It is a good alternative to complicated nested IF 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