WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to Use If Value Function in Excel

August 9, 2022
3.3K Views

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 (C3Drag 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


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.