WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        2296 results for use if function in excel

        • All Tutorials
        • Video Tutorials
        • Quick Tutorials
        • All
        • Spreadsheet
        • Presentation
        • Writer
        • PDF

        2296 results for use if function in excel

        Use IF function to judge data

        Use IF function to judge data

        01:48

        Use IF function to judge data

        The IF function can judge the specified condition and give two results when the condition is established and when it is not.Here is a staff interview form. Now we need to count the people who passed the interview quickly. If the interview score is greater than or equal to 6, the interviewee is passed, but the interviewee is unqualified if the interview score is less than 6. Here, we can use the IF function to judge the result of the interview quickly. The IF function syntax is as follo....

        Spreadsheet 45.0K views
        Use the text function to extract characters in cells

        Use the text function to extract characters in cells

        02:45

        Use the text function to extract characters in cells

        In this video, we'll introduce three practical functions in excel, which are the RIGHT, LEFT, and MID functions.In this example, if we want to extract the first three numbers on the right, how can we realize it? The RIGHT function could help. It can extract characters within a cell, from the right to the left. Here is the complete formula of the RIGHT function. RIGHT(text,num_chars) The first parameter text refers to the specific text to be extracted. The second parameter num_chars....

        Spreadsheet 9.5K views
        How to use the Quick Parts function in WPS Writer

        How to use the Quick Parts function in WPS Writer

        02:20

        How to use the Quick Parts function in WPS Writer

        Do you know how to skillfully use the Quick Parts function to improve efficiency instead of inputting tedious content repeatedly?In our daily life, the Quick Parts function is mainly used in two ways. · Input commonly used text quickly.The Quick Parts function is to save and reuse specified parts of the text, which act like building blocks. When we need to input the same thing repeatedly, we can build such building blocks in the document for quick use, that is, to create quick parts. T....

        Writer 7.7K views
        How to use the MID function in WPS Spreadsheet

        How to use the MID function in WPS Spreadsheet

        01:54

        How to use the MID function in WPS Spreadsheet

        When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....

        Spreadsheet 9.8K views
        How to use the Arrange All function in WPS Presentation

        How to use the Arrange All function in WPS Presentation

        00:50

        How to use the Arrange All function in WPS Presentation

        We may need to refer to multiple documents when editing slides, but it is troublesome to switch back and forth. At this point, we can use the Arrange All function to display multiple documents at the same time. 1. Click the View tab and click Arrange All.2. Here we select Tile Horizontal. Then the currently open presentations can be identified intelligently and arranged in a horizontal tile. 3. According to personal habits, we can also select Vertical Text Box, or Cascade.4. If we want....

        Presentation 6.3K views
        How to use the formula function of table in WPS Writer

        How to use the formula function of table in WPS Writer

        02:38

        How to use the formula function of table in WPS Writer

        You know what? In WPS Writer, not only can we perform simple calculations on the table data, but apply the formulas of built-in functions. Here are a few commonly used functions for you to explore. Take this table as an example. Assume that we want to count how many Expense there are in the whole table. We can use the COUNT function to count the number of data in the table.Tips: The COUNT function in WPS can only be applied in counting number data, while the empty cells, logical value....

        Writer 9.1K views
        How to use the Trace Dependents function in WPS Spreadsheet

        How to use the Trace Dependents function in WPS Spreadsheet

        01:37

        How to use the Trace Dependents function in WPS Spreadsheet

        When working with data tables, especially when the data is referenced multiple times, we can find potential errors by tracing dependents. Take this worksheet as an example. The net profit in the table is calculated from the total amount of sales minus the cost of purchases. Normally, it is difficult to detect if the figures are misquoted.If we want to check whether the total sales are correct, we can select the sales price in cell F8, head to the Formulas tab, and click the Trace Dep....

        Spreadsheet 6.7K views
        How to use the Spell Check function in WPS Spreadsheet

        How to use the Spell Check function in WPS Spreadsheet

        02:15

        How to use the Spell Check function in WPS Spreadsheet

        The Spell Check function of WPS Spreadsheet can help us quickly trap misspelled words and provide suggestions for correction, greatly saving the calibration time of the table.In the Review tab, click the Spell Check button and open the Spell Check dialog box, whose shortcut key is F7.In the text box on the left, we can see some words marked in red. These are the words in which WPS Office has detected possible spelling mistakes. Take this table as an example. The cells are checked from ....

        Spreadsheet 12.6K views
        Prev 1 2 3 ... 286 287 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube