How to Use If Value Function in Excel
A free Office suite fully compatible with Microsoft Office
When you are working in Excel Spreadsheet in WPS, you need excel if value function for logical comparison between two values. An IF value statement can have two outcome The first result is if your comparison is right, the second if your comparison is wrong. People get confused and found very difficult to use excel if value functions.
However, using WPS excel spreadsheet is very simple and helpful only if you know the right steps and methods. This article will help you to understand the steps involves to use excel if value function in excel/spreadsheet WPS and after reading the article you can easily perform this task in your WPS Office (2016/2019/mac/online).
Followings are the simple steps to be followed to easily understand this task,
Different ways to use Excel IF value function in Excel Spreadsheet (2016/2019/Mac/Online)
How to use excel IF value for logical test (True/False).
1.Go to your excel spreadsheet
2.Select the data on which you want logical test using IF value.
For example we want to run logical test on students test result. We want to allocate either Pass or Fail based on a test score. The passing score is 50 or higher in marks column.
If the value in Column C is greater than 50, return Pass. Otherwise, return Fail.
Go to the cell where you want logical test.
Write the formula as =IF (C3<50,’’Fail”,”Pass’’) in cell.Drag down to last cell and the result will be displayed in that cell as Fail or Pass.
How to use excel IF value to Check if Cell is Blank
Sometimes you want to verify if a cell is blank, usually because you may not want a formula to show a result without input.In this case you can use “IFBLANK” Function
For example we want to specify for the logical result that no result is returned if no delivery date has been entered in delivery cell.
And if the delivery date is entered in cell days to complete the order will be displayed. For this test we will use ISBLANK function,The Formula will be as =IF(ISBLANK(E6),,E6-D6)
How to use COUNTIF function
COUNTIF is a function that is used to count the number of cells that meet a criterion. It has two arguments Range and Criteria.
Select the Range of Cells and set the criteria to look for it in Data.
For Example we look for name of person that how many times it has been in that data. In our Data we want to check that how many times “Atif” has been in that cell,Go to your excel spreadsheetWrite the formula as =COUNTIF (D5:D16,Atif).Press Enter and the Count of Name will be displayed.
This article has covered the methods on How to use Excel IF Value function in excel spreadsheet WPS. You can use these simple steps as explained above and easily use Excel IF Value in your WPS Office (2016/2019/Mac/Online) whenever required.
Hopefully, you have learned How to use Excel IF Value in WPS Office (2016/2019/Mac/Online) by following the above steps. If you want to know more about Word features, you can follow WPS Academy to learn. You can also download WPS Office to edit the word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience
Was this helpful?
- 1. How to compare two excel sheets and highlight differences
- 2. How to expand cells to fit text in Excel
- 3. How to copy file names in Excel from a folder?
- 4. How to import external data in WPS Spreadsheet
- 5. How to use the VLOOKUP function across multiple sheets in WPS Office Excel?
- 6. Check if value is in list in Excel (3 easy methods)