1, IF function =IF (judging the condition, the value returned by the condition is true and the value returned by the condition is not true) =IF(AND (condition 1, condition 2), the values returned by both conditions are true and not true) =IF(OR (condition 1, condition 2).
2.Round function and INT function
3.Vlookup function
4.Sumif and Countif functions
5.Datedif function =Datedif (number of years between start date and end date "y" = datedif (number of months between start date and end date "m") = datedif (number of days between start date and end date "d").
6. Maximum calculation function =MAX (region) returns the maximum value =MIN (region) returns the minimum value =Large (region, n) returns the nth maximum value, that is, =Small (region, n) returns the nth minimum value.
Introduction to WPS:
WPS is an office software brand independently developed by Jinshan Software Company. It integrates editing and printing, has rich full-screen editing functions, and also provides a variety of control output formats and printing functions, so that the printed manuscript is beautiful and standardized, which can basically meet the needs and requirements of writers from all walks of life to edit and print various files.
First appeared in 1989. Before the appearance of Microsoft Windows system and the prevalence of DOS system, WPS was once a popular word processing software in China. Now the latest version of WPS is 2022 Personal Edition, Enterprise Edition and 2022 Campus Edition. In Chinese mainland.
Jinshan Software Company beat Microsoft Company many times in government procurement. Now many governments and institutions in Chinese mainland are equipped with WPS office software, which is very popular in colleges and universities because of its free, exquisite and easy to use.
Recommended function:
The compatibility between WPS 2005 and foreign mainstream Office is not the general one-way compatibility that WPS 2005 can only open other Office files, but the breakthrough two-way compatibility. Format compatibility is not limited to this, pay attention to the files read by MS Office and WPS 2005.
Whether it is a Chinese document or an English document, it can achieve the exact effect of word for word and line for line. To achieve this precise compatibility, Jinshan Company must have made a major breakthrough in technology. Because some foreign Office companies once thought that word-to-word and line-to-line compatibility was impossible.
It is not only the compatibility of file format and operating habits, but also that WPS Office can directly open encrypted DOC, XLS and PPT files when it knows the password, which is an unexpected discovery after trial. Moreover, WPS Office2005 can also directly open DOC documents with macro codes, which relieves the worries of advanced users of MS Office when transferring files.
The realization of two deep compatibility, the opening of encryption and decryption file channel and the direct operation of VBA macro code are still technical bottlenecks that other office software can't break through.
WPS tables can be referenced across Excel files. If the referenced XLS file data changes, the referenced data in the WPS table file will also be updated synchronously. This function embodies the data consistency and application leap of product compatibility. WPS demonstration is highly compatible in animation effect, graphic type and multi-motherboard support.