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

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

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

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

Use the ROW function in WPS Spreadsheets for row numbering

When using WPS Spreadsheets to process data, how can we deal with the worksheets without numbering or those with disordered numbers? Are there any convenient ways to number the rows while the numbers are not supposed to get disordered when certain rows are removed? The ROW function can realize it. The complete ROW formula is =ROW([Reference]). Here Reference can refer to a single cell, a cell range, or nothing. Here is the introduction to the two options of using the ROW function. · O....

The AVERAGE, MAXIMUM, MINIMUM functions

When we analyze the sales performance of staff, the AVERAGE, MAXIMUM, and MINIMUM functions can help a lot. The worksheet on the screen lists the personal sales performance for each staff.If we want to get the average sales, we can use the AVERAGE function. Click cell C22, and enter the formula "=AVERAGE()". Then, input "E3-G21" within the parentheses, and press Enter to get the result.If we want to know the highest sales, we can use the MAX function. Click cell E22, and enter the form....

The Trace Precedents function

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. While processing a table, we have to double-click a cell containing a function formula to view the referenced data cell, However, this will easily lead to incorrect editing of the formula. At this time, we can use the function of Tracking Precedents of WPS table.Take this table as an example. We want to see which cells are referenced by the formula of ....

Use IFS function to check whether multiple conditions are met

When judging multiple conditions, lengthy IF function will make it difficult for others to understand the logic when editing, here, IFS function can be put to good use.The grammatical structure of IFS function is "= IFS (logical _ test1, value _ if _ true1, [logical _ test2, value _ if _ true2], ...)", making nesting layer by layer unnecessary, thus simplifying the formula. Taking this form as an example, we would like to grade students' scores according to the four conditions of ....