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 …
In our 8th lesson, I will discuss COUNT, COUNTIF, and the combination of IF and COUNTIF. COUNT is a function that counts the number of cells in a range that contains a number. I have given an example of COUNT …
Lesson#8: COUNT, COUNTIF, and combination of IF and COUNTIF Read more »
In this post we will discuss nested IF making. I have to show Grade on the mark sheet so I will check multiple conditions by IF. The structure of nested IF will be like this =IF(E5<85,IF(E5<70,IF(E5<55,IF(E5<40, IF(E5<25, “F”, “E”), “D”), “C”), …
In this post, we will discuss function IF. IF is a logical function that checks whether a condition is met and then returns a value if TRUE or another value if FALSE. Syntax of function IF is =IF(logic_test, value_if true, …
In this post, we will learn a very useful function, VLOOKUP (Vertical Lookup, or value lookup in columns), by which we can easily find data within a table. I have madea Data Validation (List) within a cell, which shows the …