HOW TO USE EXCEL IFS FUNCTION

Introduction IFS comes in the category of logical functions. IFS function can be used for logical comparison of values and to get the first result when the comparison is TRUE and second result when the comparison is FALSE. IFS function can do multiple tests in a single run and is a very good alternative of nested IF function. It is evaluated by putting various logical operators like “=”,”>”,”<” etc. in the formula .IFS function is also used in combination with…

Continue Reading

Employee attendance sheet in excel with formula

Attendance management is the crucial part for Human resource department. This is required for leave balance calculation and salary processing. In case of a small organization with few employees, this can be maintained in the excel template. This attendance sheet in excel with formula will help in leave and attendance management of employees with visualization dashboard. Before using this template, please read following points: This template can be used for monitoring the attendance and leave for one month. You have…

Continue Reading

How to use Excel CLEAN Function

Introduction CLEAN in excel is a text/string function. This function cleans non printable elements and line breaks in a text. It can be used to omit non printable elements from text that has been imported from other software or online links, which is not usable in your operating system. For example, ($week©) can be cleaned by using =CLEAN($week©) formula which gives (week) as the result. Syntax =CLEAN(Text) Arguments Text: It is the text which will be cleaned, cell number which…

Continue Reading

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
Close Menu
×

Cart