How to use Excel CODE Function

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 will be retrieved. Keynotes This function was added in Excel 2000 and is available in later versions also.If text argument…

Continue Reading

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) Arguments Number: It is a value lying from 1 to 255. Keynotes Excel online only used Character set (9, 10,…

Continue Reading

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 explicitly rounds down negative integers. Syntax =FLOOR.MATH(Number, Significance, Mode) Arguments Number- The number or cell containing the number that is…

Continue Reading

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…

Continue Reading

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 function. Syntax =IFNA(value,value_if_na) Arguments Value- Value whose error has to be checked.Value_if_na- Custom value to be retrieved if error is…

Continue Reading

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 is to be rounded off. Keynotes If argument is non numeric, #VALUE! error is displayed.Numbers with negative sign are rounded…

Continue Reading

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 to be rounded off.Multiple- It is the multiple to which you can round the number. Keynotes MROUND function rounds up…

Continue Reading

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 =ROUNDDOWN(Number, Num_Digits) Arguments Number- The number or cell containing the number that is to be rounded off.Num_Digits- It is the…

Continue Reading

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 come in bundles of odd numbers. Syntax =ODD(Number) Arguments Number- The number or cell containing the number that is to…

Continue Reading

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 =ROUNDUP(Number, Num_Digits) Arguments Number- The number or cell containing the number that is to be rounded off.Num_Digits- It is the…

Continue Reading
Close Menu