Three functions LEFT, RIGHT, and MID is very useful for extracting characters from a text string. In this post, we will discuss these three functions.LEFT is a function that returns the specified number of characters from the start of a …
Lesson#21: Extracting data with LEFT, RIGHT and MID function Read more »
In this post, we will talk about the formula DATEDIF(). This the formula is used to get the difference in days, months, or years between two dates. In excel we are unable to find any help with the formula but …
Lesson#20: Making an age calculator in excel with DATEDIF function Read more »
In this lesson, we will learn a method to convert digits into words. I will use functions like CONCATENATE, VLOOKUP, SUM, IF, and MOD, which were discussed in my previous posts. 1st Step I have made a list of relevant …
Lesson#19: How to convert digit into word in excel Read more »
MOD function returns the remainder after dividing a number with a divisor. Syntax of the function is =MOD(number, divisor). Let me show you an example. I have typed a random number 123456789 then I will add the MOD function to …
Function IFERROR returns the value_if_error if the expression is an error and the value of the expression or reference. Syntax of the function =IFERROR(value, value_if_error). Here I will give you a small example. Here in the picture, you can see …
Lesson#16 will introduce you to some more new function TODAY, NOW, HOUR, MINUTE, SECOND, YEARFRAC. Function TODAY returns the current date formatted as a date. Function NOW returns the current date and time formatted as date and time. HOUR(serial_number) returns the hour as a …
Lesson#16: Know about function TODAY, NOW, HOUR, MINUTE, SECOND, YEARFRAC Read more »
In this post, we will talk about the functions DATE, DAY, MONTH, and YEAR. DATE function converts date, month, and year values into single-line date format. Let me show you an example. I have written DAY, MONTH, and YEAR for …
Lesson#15: Know about functions DATE, DAY, MONTH, YEAR Read more »
CONCATENATE function joins several text strings into one text line. In this post, I will show you some examples of CONCATENATE. Syntax of CONCATENATE is =CONCATENATE(text1, [text2], …..) I made a sheet that shows to enter the NAME, MIDDLE NAME, and …
Hello friends! in this post I will give you an example of making a SIP planner in Excel. As you know there are so many apps in the market to calculate SIP (Systematic Investment Plan) but it would be nice …
Function SUMIF adds cells specified by a given condition or criteria. Syntax of function SUMIF is =SUMIF (range, criteria, [sum_range]) Where range is the range of the array from where the criteria will be matched. [sum_range] is the range from where the …