How to use Excel ASC Function

Introduction ACS in excel is a text/string function. It is used in case of double byte character set to convert full width(double-byte) to half width(single-byte) characters. This function is useful for multiple languages and unique characters. For example, =ASC(“PRINCE”)gives PRINCE as the result. Syntax =ASC(Text) Arguments Text: It is the text or reference which contains the characters you wants to convert to single bytes. Keynotes The maximum characters possible in one byte is 265 while in two bytes maximum characters…

Continue Reading

How to use excel DATEVALUE function

Introduction DATEVALUE function in Excel is a type of DATEVALUE/TIME function. This function is used to change a date which is in form of text to a valid excel format and gives result in form of serial number in the Excel date system. For example, formula =DATEVALUE(12/09/2018) gives 43443 as the result.  Syntax =DATEVALUE(Date_Text) Arguments Date_Text-  It is the text or cell reference which represents the date value in valid excel format. Keynotes In General formatting of Excel, DATEVALUE function…

Continue Reading

How to use Excel DAYS Function

Introduction DAYS 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 the DAYS into other functions, for example in DATE function. Syntax =DAYS(end_date,start_date) Arguments End_Date- The end date to which one wants to calculate the number of…

Continue Reading

How to use Excel DAYS360 Function

Introduction DAYS360 function in Excel is a type of DATE/TIME function. It gives value of the number of days falling between two dates by considering a 360 days year. It does so by considering every month of the year to be consisting of 30 days. 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 the days into other…

Continue Reading

How to use Excel CONCAT Function

Introduction CONCAT in excel is a text/string function. This function is used to merge several text strings or ranges. This function was included in Excel 2016 and available in later versions, it replaced CONCATENATE function. This function does not include delimiter/Ignore Empty arguments. Syntax =CONCAT(Text1, Text2, ….) Arguments Text1: It is the text values which will be merged together, can be a string or an array of strings or a range of cells.Text2:  Additional text values to be joined, maximum…

Continue Reading

How to use Excel DBCS Function

Introduction DBCS function in excel is a text/string function. Its full form is (Double Byte Character Set). 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. For example, =DBCS(“PRINCE) gives PRINCE as the result. Syntax =DBCS(Text) Arguments Text: It is the text or reference which contains the characters you wants to convert to…

Continue Reading

How to use Excel DOLLAR Function

Introduction DOLLAR in excel is a text/string function. This function converts a numeric value into text value using Currency Format and it also rounds off decimal places to the value specified. The currency character used is dependent on the local languages settings. Format which this function uses is$#,##0.00_);($#,##0.00). For example, 12 is converted to $12 by using the formula =DOLLAR(12) Syntax =DOLLAR(Number, Decimals) Arguments Number: It is the number or a reference to a cell which contains the number.Decimals: It…

Continue Reading

How to use Excel CEILING.PRECISE function

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

Continue Reading

How to use Excel FORMULATEXT function

Introduction FORMULATEXT function in excel is a Math/Trig function. It is a worksheet function. This function is used to retrieve a formula from a reference in form of a text string. Syntax =FORMULATEXT(Reference) Arguments Reference- t is the reference made to a range or cell. Keynotes Reference argument can be from other worksheet also.If the other worksheet to which reference is made is not open, #N/A error is displayed.If the reference is made two an entire range, the value in…

Continue Reading

How to use Excel CEILING.MATH function

Introduction CEILING.MATH 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.MATH(1.5,1) which gives 2 as the result. CEILING.MATH function is different from CEILING as it uses 1 as a default multiple and explicitly rounds up negative integers. Syntax =CEILING.MATH(Number, Significance, Mode) Arguments Number- The number or cell containing the number that is…

Continue Reading
Close Menu
×

Cart