How to use Excel ACCRINTM Function

Introduction:- ACCRINTM function in excel is a financial function. It is used to find accrued interest for a security that pays interest at maturity. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ACCRINTM(issue_date, maturity_date, rate, par, basis) Arguments:- Issue_Date: It is the date on which security is used. Maturity_Date: It is the date on which security will be matured. Rate: Annual coupon rate of the security. Par: It is the…

Continue Reading

How to use Excel AMORDEGRC Function

Introduction:- AMORDEGRC function in excel is a financial function. It is used to retrieve the depreciation value for every accounting period. It is mainly useful in prorated depreciation calculation. It is different from AMORLINC in a way that here depreciation coefficient is used depending on life of assets. Syntax:- =AMORDEGRC(cost, date_purchased, first_period, salvage period, rate, basis) Arguments:- Cost: It is cost of the assets. Date_Purchased: It is the date on which assets is purchased. First_Period:  It is the date on…

Continue Reading

How to use Excel JIS Function

Introduction:- JIS function in excel is a text/string function. I. This function is used to convert single byte characters into double byte characters in a text string. This function is useful for multiple languages and unique characters. Half width characters are converted to full width characters. This function was replaced by DBCS function from excel 2013 onward. For example, =JIS(“PRINCE) gives PRINCE as the result. Syntax:- =JIS(Text) Arguments:- Text: It is the text or reference which contains the characters you…

Continue Reading

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…

Continue Reading

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…

Continue Reading

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…

Continue Reading

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.…

Continue Reading

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…

Continue Reading

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…

Continue Reading

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…

Continue Reading
Close Menu
×

Cart