:N function converts non-numeric values into numeric values-Table skills免费ppt模版下载-道格办公

N function converts non-numeric values into numeric values

Picture and text skills
Case

Returns the value converted into a numeric value.

Syntax
N(value)
Value is the value to be converted. Function N can convert the values listed in the following table:

Description
• It is generally not necessary to use the function N in the formula because WPSThe table will automatically convert the values as needed. This function is provided for interoperability with other

Spreadsheet program compatible.
• WPSTable stores dates as serial numbers that can be used for calculations. By default, the serial number for December 31, 1899 is 1 and January 1, 2008

's serial number is 39448 because it is 39448 days from December 31, 1899.

The N function is an information function, its function is to convert non-numeric values into numerical form.
The following will explain the usage of this function in detail to help you understand this function.

￭First place the cursor at C3 and click to insert the N function.
A dialog box will pop up, and the value is the value that needs to be converted.
It should be noted that if the value is a number, the number is returned, and if the value is a date, the serial number of the date is returned.
If the value is a logical value TRUE, 1 is returned; FALSE, 0 is returned.
If the value contains text format, 0 is returned.
We enter B3 in the value and click OK to convert this value into numerical form.
Place the cursor in the lower right corner of C3 and form a cross-shaped drop-down menu to fill in the formula to perform batch conversion.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/N-han-shu-jiang-fei-shu-zhi-zhuan-huan-cheng-shu-zhi.html