Introduction:- COUNTBLANK function in excel is a statistical function. This function is used to count empty cells and cells containing text values, numbers, logical values etc. are not used in counting. This is a worksheet function and can be entered into the cell in which COUNTBLANK is required. Syntax:- =COUNTBLANK(Range) Arguments:- Range: It is the … Read more
Introduction:- COUNTA function in excel is a statistical function. This function is used to count the number of values that are numbers, text, error values, logical values, empty text; usually these are the cells that contain numbers, text, error values, logical values, empty text. This is a worksheet function and can be entered into the … Read more
Introduction:- COUNT function in excel is a statistical function. This function is used to count the number of values that are numbers; usually these are the cells that contain numbers. This is a worksheet function and can be entered into the cell in which count is required. Syntax:- =COUNT(value1, value2, …., …) Arguments:- Value1: 1st … Read more
Introduction:- CORREL function in excel is a statistical function. It is used to find correlation between two variables and gives correlation coefficient having value between +1 and -1. A value of +1 means a perfect directly proportional relation is present and a value of -1 means a perfect inversely proportional relation is present. It is … Read more
Introduction:- AMORLINC 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 AMORDEGRC function in a way that in AMORDGERC function, depreciation coefficient is used depending on life of assets. Syntax:- =AMORLINC(cost, date_purchased, first_period, … Read more
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 … Read more
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
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
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
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