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

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

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

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

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

HOW TO USE EXCEL IFS FUNCTION

Introduction IFS comes in the category of logical functions. IFS function can be used for logical comparison of values and to get the first result when the comparison is TRUE and second result when the comparison is FALSE. IFS function can do multiple tests in a single run and is a very good alternative of … Read more