In our 8th lesson I will discuss about COUNT, COUNTIF and combination of IF and COUNTIF. COUNT is a function which counts the number of cell in a range which contains number. I have given example of COUNT in above two pictures. Now I will show what is COUNTIF and how they can be…
I this post we will discuss about nested IF making. I have to show Grade on mark sheet so I will check multiple condition 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”), “B”),”A”) which is shown in above picture. 1st layer: If the marks is Less the…
In this post we will discuss about function IF. IF is a logical function which checks whether a condition met then returns a value if TRUE or another value if FALSE. Syntax of function IF is =IF(logic_test, value_if true, value_if_false). I have added a row to show a simple example of IF by showing the marks…
In this post we will learn a very useful function VLOOKUP (Vertical Lookup, or value lookup in columns) by which we can easily find a data within a table. I have made Data Validation (List) within a cell which shows roll number. Now I will use VLOOKUP to show the relevant student name automatically when…
In this post we will learn a function DATA VALIDATION. This is a very useful for making a proper data entry. I will give a good example where we can use it. I made a report card format in another sheet which will show the report card of any student in this format. I have…
We made a table of mark sheet in previous post now we will learn something new. We will learn showing percentage, function MAX and function MIN I have added columns in right hand and put total marks there which is 6*100=600 in every row. Then another column is for showing percentage of marks scored by…
We will learn how to make a table with a simple mark-sheet example and we will learn SUM function and AVERAGE function. This is a table I have made. In left side there are names of students, on top subjects and I have put the marks the have scored against the subject. Now what we…
OK friends. This is going to my first lesson. The ABCD of Excel starts here. We will learn how to make basic operations in Excel. How to add, subtract, multiply and divide two numbers. This picture now shows how to make addition between two numbers. Select the first cell then press ‘+’ then select second…
Why Excel? Microsoft Excel is a very powerful software developed by Microsoft Inc. It’s a spreadsheet software where we can make any type of data calculation, chart, graph preparation. It is very much useful and widely used in offices all over world. Any type of mathematical data, business data easily calculated within seconds by using formulas….
