TEXT formula in WPS Spreadsheet

The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....

Use formula to set the conditional formatting

Take this table as an example. We can use the formula to set the conditional formatting by ourselves and mark the finished projects. Select the cell range A2:C22, and get into the Home tab. Click the Conditional Formatting drop-down button, and choose the New Rule option. In the pop-up dialog, we choose the Use a formula to determine which cells to format option.In the Format only cells with edit box, enter the formula "=$C2="Finished" ". The absolute reference has been added to the co....

How to use the Excel MID function

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....

How to add a watermark

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.We often see unique watermarks printed on the back of some files. Adding a watermark can not only prevent others from embezzling but also can help us to indicate the source of the article. So how can we add a watermark to a document?To show the source, we need to add the watermark of WPS Academy to the following documents now.1. After cl....

How to add background to PDF files

When we are editing PDF documents, if the entire white layout is too simple, we can add a nice background. Let's learn the tips for beautifying PDF files with WPS Academy. Take this document as an example. Click the Insert tab, the Background drop-down menu, and then click Add Background. In the dialog box, we can add pure color background to the document, or customize the background image. Click Browse and select a suitable picture from the computer.In Surface, we can adjust the r....

How to add and set the numbering in WPS Presentation

WPS Office is a comprehensive office suite that includes writer, spreadsheet, presentation and PDF editor all within one single software.When using WPS presentation, we may want to add numbering to make our slides look more organized. So, how can we add numbering?Select the text content that needs to be added with numbering, click the Home tab above, and then click the Numbering button. Here, we can see a variety of preset numbering provided by WPS. Click to select a style to add. If w....

How can we add or remove text shading

When using WPS Writer to edit documents, we can add shading to highlight some parts of the text content. So how can we add and remove text shading? Take this document as an example. If we want to highlight the students mentioned in the notice, we can select this part of the content and click the Character Shading command button in the Home tab. By this, we can quickly add a gray shading to the selected content. Gray is the default color. If we want to delete the shading, just click the....

The SUMPRODUCT function for quick calculation of total sales

When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....