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, … Read more

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 … Read more

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 … Read more

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 … Read more

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 … Read more

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 … Read more

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 … Read more

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 … Read more