People often need to conceal result in WPS when managing documents. Unfortunately, few applications offer the features you need to accomplish this task. To do something like this typically involves switching between several software applications, which take time and effort. Thankfully, there is a solution that suits almost any job: DocHub.
DocHub is a perfectly-built PDF editor with a full set of valuable functions in one place. Editing, signing, and sharing paperwork is simple with our online tool, which you can use from any online device.
By following these five simple steps, you'll have your modified WPS rapidly. The intuitive interface makes the process fast and effective - stopping jumping between windows. Try DocHub now!
this is a table of information about the department employees if we need to calculate the average weight of the staff what should we do normally you only need to enter the formula equals average d2 through d8 in cell d9 to get the average however the formula returns zero and obviously the result is incorrect because there are text characters in the cells which affects the accuracy of the calculation do you know how to retain the weight unit and normally perform the calculation at the same time at this time we can customize the cell format to solve this problem select the range of cells to which we want to apply the calculation and press the shortcut control 1. in the pop-up dialog select custom enter the formula 0 kg in the edit box where 0 represents the numeric placeholder and double quotes represent the quoted text then click to confirm when we enter the input number the unit symbol kg will be added after the number automatically enter the formula equals average d2 through d
