{oapdf_gg}
Office software is closely linked to the PDF,the PDF is also must have to control!      Set home Page  Add to Favorites  
You are here:Home > OA application skills > EXCEL skills
EXCEL skills
Application of Excel function tutorials explain the information function (with examples)
Finishing by: Date:2009-04-11 12:58:02 Popularity: Tags:tutorials

six test parameters of the function parity ISEVEN and ISODD

ISEVEN with parity ISODD In order to test the parameters of the function. ISEVEN which is an even number when the parameters return TRUE, otherwise return FALSE. And then ISODD the contrary, if the parameters for the odd number, return TRUE, otherwise return FALSE.

Function on these two specific examples of usage see.


Figure 8

seven, after the return into the merit function values N

Function of N for the return into numerical values. Its grammatical form of N (value) to transform them Value for value. Function N can be transformed into values The following table lists:


Figure 9

should be noted that: under normal circumstances do not have to use the function in the formula N, because Excel will be needed to convert the value automatically. This function is provided with other compatible spreadsheet program. Microsoft Excel may be the date used to calculate the storage as the serial number. By default, January 1, 1900 serial number is 1 and 1 January, 2008 is the serial number 39448, because it is from January 1, 1900 there are 39,448 days. And Excel for the Macintosh to use a default date system.

Function N on the specific use of the following example from a more detailed understanding.


Figure 10

HomePrevious12345NextEnd
Previous:Application of Excel function tutorials explain financial functions (with examples)
Next:Excel function application function logic operations detailed tutorial (with examples)
there isArticle InformationsComment Information
Category column
Ranking Information
Related Articles
Site Help | Site Map | Feedback |
OAPDF.COM Copyright 2009 V1.1