How to use If Function in excel

July 28, 2022
1.6K Views
0

A free Office suite fully compatible with Microsoft Office

A free Office suite fully compatible with Microsoft Office

Excel is a powerful tool, but it can be difficult to use if you don't know how to write formulas. Fortunately, there's an easy way around this problem that you are going to get that how to use excel if function. If function is a Logical Function that allows you to check whether a condition is true or not. This can be used in multiple ways, and it's one of the most useful Excel functions.

How to use excel if function to judge data?

Suppose we have the list of students and their mark and we want to check that which student is pass and which student is failed.

1. Open the file which have the data you want to judge once you have the file choose formulas and then click on insert Function.

2. As you click on insert function the insert function window will open now select a function and click ok.

3. After clicking ok function arguments window will be open this window have three boxes the first one is logical test type c1>=10

C1= we want to judge the data which is in c1 means the marks of students

>=10: it means that greater then or = to 10 now move to the second box.

4. Now we have the second and third boxes the second box is value if true it means if the value in c1 is greater or equal produce the result which we put in second box and third box will represent if value is not true.

So, we put pass against true and fail against fail. Now click ok.

5. After clicking OK you will get the result as we observe result in D1 is because value in C1 is less than 10.

How to use excel if function to judge data with multiple conditions?

1. Open the file which have the data you want to judge once you have the file choose formulas and then click on insert Function.

2. As you click on insert function the insert function window will open now select a function and click ok.

3. After clicking ok function arguments window will be open this window have more boxes the first one is logical test type c1

C1= we want to judge the data which is in c1 means the marks of students

And then click ok.

4. As you click ok you will get the result as shown in following picture.

You have been led through the necessary steps to illustrate how to use if function in Excel to judge the data with one and multiple conditions.

If you are interested in learning more about the WPS office, please check out the webpage for the WPS Academy where you can learn various other functions of WPS office excel, word and other. You can also download WPS Office for free from this link if you want to edit files in Word, Excel, or PowerPoint. PDF files are not supported.