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 made Data Validation (List) within a cell which shows the …
In this post, we will learn the function DATA VALIDATION. This is very useful for making a proper data entry. I will give a good example of where we can use it. I made a report card format in another …
We made a table of mark sheets in the previous post now we will learn something new. We will learn to show percentage, function MAX, and function MIN I have added columns in the right hand and put total marks …
Lesson#3: Showing percentage, learning function MAX, function MIN Read more »
We will learn how to make a table with a simple mark-sheet example and we will learn the Excel SUM and AVERAGE functions. This is a table I have made. On the left side, there are names of students, on …
Lesson#2: Making and formatting table, SUM function, and AVERAGE functions Read more »
OK friends. This is going to be 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 …
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, or graph preparation. It is very much useful and widely used in offices …