HOW TO USE EXCEL SWITCH FUNCTION

Introduction SWITCH comes in the category of logical functions. SWITCH function can be used for logical comparison of an expression to a list of values and to get the corresponding result. This can do multiple tests in a single run. ¬†Difference between SWITCH and IFS function is that SWITCH function evaluates only an exact match and does not use operators such as less than and greater than .SWITCH is also used in combination with other functions like AND , OR…

Continue Reading

Excel Calendar for 2019 and any year

Wish you very happy new year 2019. May the New Year bring you delight, health and happiness in all your endeavors. To learn something grate and interesting stuffs in excel, subscribe to excelhub.org. In the year 2019 my target is to publish all 450+ excel functions and many more things here. Excel Calendar for 2019 In this post i will explain you how to use this excel calendar for 2019 or for any year. How to use Excel Calendar for 2019 The calendar is prepared using excel…

Continue Reading

How to use Excel MATCH function

Introduction MATCH function in excel is a lookup function. It helps in locating cell number corresponding to a lookup value of a row, column or table. It does this by searching for specific value in a range of cells and returns position of value. For Example, if the range A3:A6 have the values 10, 15, 20 respectively then function =MATCH(20,A3:A6,0) gives value 3 as 20 is 3rd in the range. It is also used commonly with the INDEX function. Syntax…

Continue Reading

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) Arguments Number- The number or cell containing the number that is to be rounded off.Multiple- It is the multiple to…

Continue Reading

How to use Excel ROUND function

Introduction Round function in excel is a Math/Trig function. It is a worksheet function. It is used in rounding of a number to a defined number of digits. For example, if cell B1 contains value 2.478 and it needs to be rounded off to one decimal place, one can used ROUND function to return value 2.5 Syntax =ROUND(Number, Num_Digits) Arguments Number- The number or cell containing the number that is to be rounded off.Num_Digits- The number of digits to which…

Continue Reading

How to use Excel IFERROR function

Introduction IFERROR 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 errors like #VALUE! , #NUM! , #N/A! , #REF! , #NAME! etc. If no error is found IFERROR returns the calculated value of the formula. It is a good alternative to complicated nested IF function. Syntax =IFERROR(value,value_if_error) Arguments Value- Value whose error has to…

Continue Reading

How to use Excel FLOOR.PRECISE function

Introduction FLOOR.PRECISE function in excel is a Math/Trig function. It is a worksheet function. It rounds down the given function to a defined multiple or the nearest integer. It is different from FLOOR function in the sense that whatever may be the sign of the number, it always rounds down. By default it uses 1 as a multiple. For example, number 2.5 is rounded down to nearest multiple of 1 by formula =FLOOR.PRECISE(2.5,1) which gives 2 as the result. Syntax…

Continue Reading

How to use Excel NOW function

Introduction NOW function in Excel is a type of DATE/TIME function. This function is used to retrieve present date with time. It is a dynamic function and updates automatically when we change a is made to the file or it is reopened. It gives result in form of serial number which can be formatted in form of date or date with time by using number format. Syntax =NOW() Arguments NOW requires no arguments, but parenthesis are required Keynotes In General…

Continue Reading

How to use Excel HYPERLINK function

Introduction HYPERLINK function in excel a shortcut function that creates a shortcut in the cell in which it is used. This shortcut may contain a reference to another cell of the same worksheet or another worksheet OR may contain a link to a network, internet, web, and intranet. When one clicks on the cell containing that hyperlink, excel opens the link provided in the function. Syntax =HYPERLINK(Link_location, Friendly_name) Arguments Link_Location- It is name of the file or its path which…

Continue Reading

How to use Excel WORKDAY function

Introduction WORKDAY function in Excel is a type of DATE/TIME function. This function is used to retrieve a date which represents a number of working days in future or past of a specified date. This function also omits any holidays or weekends which are specified in the syntax. This function was introduced in Excel 2007 and is built in later versions. For use in versions earlier than Excel 2007, Analysis ToolPak needs to be enabled. Syntax =WORKDAY( Start_Date,Days,Holiday ) Arguments…

Continue Reading
Close Menu