Formula Archives - Excelhub

How to use Excel UNICODE Function

Introduction UNICODE function are text/string function in excel. This function is used to find out number corresponding to a Unicode character. Unicode is in form of decimal numbers from 0 to 65535. It retrieves number of first character of a text string. This function was introduced in Excel 2013 and later versions. It is a worksheet function and can be entered in the cell of a worksheet. Syntax =UNICODE( Text) Arguments Text: It is the text string or a single…

How to use excel TIMEVALUE function

Introduction TIMEVALUE function in Excel is a type of TIMEVALUE/TIME function. This function is used to change time which is in form of text to a valid excel format and gives result in form of serial number in the Excel time system. For example, formula =TIMEVALUE(“11:02 AM”) gives 0.459722 as the result. Syntax =TIMEVALUE(Time_Text) Arguments Time_Text- It is the text or cell reference which represents the time value in valid excel format. Keynotes In General formatting of Excel, TIMEVALUE function…

How to use Excel UNICHAR Function

Introduction UNICHAR function are text/string function in excel. This function is used to find out Unicode character of a defined number. Unicode is in form of decimal numbers from 0 to 65535.This function was introduced in Excel 2013 and later versions. It is a worksheet function and can be entered in the cell of a worksheet. Syntax =UNICHAR( Number) Arguments Number: It is the number which will be used to find the Unicode character Keynotes Unicode character retrieved may also…

How to use Excel REPT Function

Introduction REPT function in excel is a built in text/string function. This function is used to repeat characters a given number of times. For example, =REPT(A, 2) gives AA as the result. It is also used as worksheet function and can be entered in cell of a worksheet. Syntax =REPT(Text, Number ) Arguments Text: It is the text or reference to a cell containing the text, which will be repeated Number: Number of times you wants to repeat the text.…

How to use Excel SECOND Function

Introduction SECOND function in Excel is a type of DATE/TIME function. This function is used to find seconds from a given time. It gives result in form of numbers ranging from 0 to 59. For example, for time 10:15:33 AM, SECOND function will retrieve 33 as the result. SECOND can also be used with the TIME function for feeding seconds into this function. Syntax =SECOND(Serial_Number) Arguments Serial_Number- This is time in a valid excel format or a cell number containing…

How to use Excel NETWORKDAYS.INTLFunction

Introduction NETWORKDAYS.INTL function in Excel is a type of DATE/TIME function. It gives value of the number of DAYS falling between two dates. This function can be applied to find the number of the days from the date present in the cell. This can also be used to extract and put the number of days into other functions, for example in DATE function. It skips weekends (Sundays and Saturdays) by default but gives an option of defining which days should…

How to use Excel TRUE Function

Introduction TRUE in excel is a built in logical type function. This function is used to return logical TRUE value. It acts as a worksheet function and can be entered in cell of a worksheet. Syntax =TRUE( ) Arguments There are no arguments for the TRUE. Keynotes TRUE function does not have any arguments and simply returns the Boolean TRUE value.It is a compatibility function. Examples In this example, some numbers are entered in column A and in Column B…

How to use Excel WORKDAY.INTL function

Introduction WORKDAY.INTL 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 is different from WORKDAY function as it allows to edit days which should be considered as weekends This function was introduced in Excel 2007 and is built in later versions.…

How to use Excel WEEKNUM Function

Introduction WEEKNUM function in Excel is a type of DATE/TIME function. This function converts a date into a number from 1 to 54 which represents number of the week. By default, first day of the week is Sunday. This function can also be used with other functions for inserting the day of the week. Syntax =WEEKNUMS(Serial_Number, Return_Type) Arguments Serial_Number: It is the date for which number of the week needs to be found.Return_Type: It is the number which represents week…

How to use Excel SEARCH, SEARCHB Function

Introduction SEARCH, SEARCHB function are text/string function in excel. These are used to locate one text string inside another text string and return its position. It is different from FIND function as it allows wildcards and also not case sensitive. SEARCHB is different from SEARCH only in case of DBCS language setting, otherwise they both behave as same. Syntax =SEARCH(Find_Text, Within_Text, Start_Num ) =SEARCHB(Find_Text, Within_Text, Start_Num ) Arguments Find_Text: The text or reference to the cell containing the text, whose…