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 …
HLOOKUP is a function that looks for a value in the top rows of a table or array and returns the value in the same column from a row you specify. It is nothing but another function for looking up …
Lesson#11: How to use the HLOOKUP function in Excel? Read more →
You are having a table full of data and you want to convert columns to rows or vice versa. Excel has a feature that is TRANSPOSE which allows pasting rows as columns and columns as rows. For Example, I have …
Lesson#10: Rotate table data from rows to column and vice versa by TRANSPOSE Read more →
In this post function, VLOOKUP is explained here once more with a very simple example. VLOOKUP looks for the value in the leftmost column of a table. It means the lookup_value column should be placed on the right side of …