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

        1733 results for round function in excel

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

        1733 results for round function in excel

        Use the ROUND function to round decimals quickly 

        Use the ROUND function to round decimals quickly 

        01:57

        Use the ROUND function to round decimals quickly 

        In our work and study, we often have to round off decimals. Let me show you how to use the ROUND function to deal with long strings of decimals quickly. Take the decimal in the B3 cell as an example.1. Place the cursor in C3.2. Click Insert Function.3. In Math and Trig, select the ROUND function. The pop-up dialog box has two parameters. Number is the numerical value to be rounded, and Num_digits refers to the digits to be used for rounding. If the Num_digits is greater than 0, then th....

        Spreadsheet 20.6K views
        The annotation function in presenting slides

        The annotation function in presenting slides

        02:58

        The annotation function in presenting slides

        If you are a teacher and need to mark your slides when presenting them in lectures, then the annotation function in WPS Presentation is perfect for you. If we place the mouse in the lower left corner when presenting slides, the shortcut menu will appear.The first two icons are used to switch slides, while the next three icons respectively correspond to the brush tool, focus and zoom tool, and other auxiliary tools. By default, we can click on the slide page to switch to the next slide....

        Presentation 10.7K views
        The AND Function in WPS Spreadsheet

        The AND Function in WPS Spreadsheet

        02:56

        The AND Function in WPS Spreadsheet

        The AND function is one of the commonly-used logical functions. When we need to test multiple conditions, it can quickly return the results. It will return TRUE if all of the arguments evaluate TRUE. Otherwise, it will return FALSE as its result. The syntax is stated as follows: AND(logical1,logical2, ...)Logical 1 is the first condition, while logical 2 is the second condition to evaluate, and up to 255 arguments are allowed in AND Function. Take this table as an example. With the sal....

        Spreadsheet 11.5K 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
        More features in Web search function

        More features in Web search function

        01:08

        More features in Web search function

        Today I will tell you the differences in the web search function between Microsoft Word and WPS Writer. When we use Microsoft Word to edit a document, we usually copy the content and open a browser to search for it if we encounter content that we do not understand. And when you use WPS Writer, you can skip this step. WPS Office has a built-in Google search engine in WPS Writer, so you only need to select the text you want to query and then click the Search button in the lower right cor....

        Writer 9.0K views
        The Word Typesetting function in WPS Writer

        The Word Typesetting function in WPS Writer

        03:05

        The Word Typesetting function in WPS Writer

        Do you want to layout your articles more efficiently? WPS Office provides us with a useful and practical function: the Word Typesetting function. Navigate to the Home tab, and click the Word Typesetting drop-down button. Then we can see a lot of text typesetting functions.Tips: you can turn on the Show/Hide Paragraph Marks button for subsequent operations.l Insert blank paragraphs In this document, for example, there is no space between paragraphs, which looks dense and does not fit th....

        Writer 18.0K 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
        The Graffiti function used to mark in PDF

        The Graffiti function used to mark in PDF

        01:41

        The Graffiti function used to mark in PDF

        Do you know how to draw on a PDF file? Let's try the "Graffiti" function! It can make your notes on PDF more fancy. Open the PDF in WPS Office. Get into the "Comment" tab, and click "Graffiti". In its dropdown list, we can access quick settings of the ink mark, including line colour, opacity, and line width. We can also use the shortcut keys "Alt+R" to open the settings window.Supposed that you need to mark continuous content, follow these few steps. Click "Draw curve". Then, choos....

        PDF 6.3K views
        Prev 1 2 3 ... 216 217 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