| Help on the following functions. | |
| Age Calculation | Using DATEDIF() |
| AutoSum shortcut key | Using Alt and = |
| Brackets in formula | Sample |
| FileName formula | Using MID() CELL() and FIND() |
| Instant Charts | Using F11 |
| Ordering Stock | Stock Ordering |
| Percentages | How to calculate various percentages |
| Project Dates | Example using date calculation. |
| Show all formula | Using Ctrl and ` |
| Split ForenameSurname | Using LEFT() RIGHT() FIND() SUBSTITUTE() |
| Time Calculation | How to calculate time. |
| TimeSheet For Flexi | Example flexi time sheet. |
| ABS | Returns the absolute value of a number |
| AND | Returns TRUE if all its arguments are TRUE |
| AVERAGE | Returns the average of its arguments |
| BIN2DEC | Converts a binary number to decimal |
| CEILING | Rounds a number to the nearest integer or to the nearest multiple of significance |
| CELL | Returns information about the formatting, location, or contents of a cell |
| CHAR | Returns the character specified by the code number |
| CHOOSE | Chooses a value from a list of values |
| CLEAN | Removes all nonprintable characters from text |
| CODE | Returns a numeric code for the first character in a text string |
| COMBIN | Returns the number of combinations for a given number of objects |
| CONCATENATE | Joins several text items into one text item |
| CONVERT | Converts a number from one measurement system to another |
| CORREL | Returns the correlation coefficient between two data sets |
| COUNT | Counts how many numbers are in the list of arguments |
| COUNTA | Counts how many values are in the list of arguments |
| COUNTBLANK | Counts the number of blank cells within a range |
| COUNTIF | Counts the number of nonblank cells within a range that meet the given criteria |
| DATE | Returns the serial number of a particular date |
| DATEDIF | Calculates the difference between two dates. Undocumented in v5/7/97 |
| DATEVALUE | Converts a date in the form of text to a serial number |
| DAVERAGE | Returns the average of selected database entries |
| DAY | Converts a serial number to a day of the month |
| DAYS360 | Calculates the number of days between two dates based on a 360-day year |
| DB | Returns the depreciation of an asset for a specified period using the fixed-declining balance method |
| DCOUNT | Counts the cells that contain numbers in a database |
| DCOUNTA | Counts nonblank cells in a database |
| DEC2BIN | Converts a decimal number to binary |
| DEC2HEX | Converts a decimal number to hexadecimal |
| DELTA | Tests whether two values are equal |
| DGET | Extracts from a database a single record that matches the specified criteria |
| DMAX | Returns the maximum value from selected database entries |
| DMIN | Returns the minimum value from selected database entries |
| DOLLAR | Converts a number to text, using currency format |
| DSUM | Adds the numbers in the field column of records in the database that match the criteria |
| EDATE | Returns the serial number of the date that is the indicated number of months before or after the start date |
| EOMONTH | Returns the serial number of the last day of the month before or after a specified number of months |
| ERROR.TYPE | Returns a number corresponding to an error type |
| EVEN | Rounds a number up to the nearest even integer |
| EXACT | Checks to see if two text values are identical |
| FACT | Returns the factorial of a number |
| FIND | Finds one text value within another (case-sensitive) |
| FIXED | Formats a number as text with a fixed number of decimals |
| FLOOR | Rounds a number down, toward zero |
| FORECAST | Returns a value along a linear trend |
| FREQUENCY | Returns a frequency distribution as a vertical array |
| GCD | Returns the greatest common divisor |
| GESTEP | Tests whether a number is greater than a threshold value |
| GROWTH | Returns values along an exponential trend |
| HEX2DEC | Converts a hexadecimal number to decimal |
| HLOOKUP | Looks in the top row of an array and returns the value of the indicated cell |
| HOUR | Converts a serial number to an hour |
| IF | Specifies a logical test to perform |
| INDEX | Uses an index to choose a value from a reference or array |
| INDIRECT | Returns a reference indicated by a text value |
| INFO | Returns information about the current operating environment |
| INT | Rounds a number down to the nearest integer |
| ISBLANK | Returns TRUE if the value is blank |
| ISERR | Returns TRUE if the value is any error value except #N/A |
| ISERROR | Returns TRUE if the value is any error value |
| ISEVEN | Returns TRUE if the number is even |
| ISLOGICAL | Returns TRUE if the value is a logical value |
| ISNA | Returns TRUE if the value is the #N/A error value |
| ISNONTEXT | Returns TRUE if the value is not text |
| ISNUMBER | Returns TRUE if the value is a number |
| ISODD | Returns TRUE if the number is odd |
| ISREF | Returns TRUE if the value is a reference |
| ISTEXT | Returns TRUE if the value is text |
| LARGE | Returns the k-th largest value in a data set |
| LCM | Returns the least common multiple |
| LEFT | Returns the leftmost characters from a text value |
| LEN | Returns the number of characters in a text string |
| LOOKUP (vector) | Looks up values in a vector or array |
| LOWER | Converts text to lowercase |
| MATCH | Looks up values in a reference or array |
| MAX | Returns the maximum value in a list of arguments |
| MEDIAN | Returns the median of the given numbers |
| MID | Returns a specific number of characters from a text string starting at the position you specify |
| MIN | Returns the minimum value in a list of arguments |
| MINUTE | Converts a serial number to a minute |
| MINVERSE | Returns the matrix inverse of an array |
| MMULT | Returns the matrix product of two arrays |
| MOD | Returns the remainder from division |
| MODE | Returns the most common value in a data set |
| MONTH | Converts a serial number to a month |
| MROUND | Returns a number rounded to the desired multiple |
| N | Returns a value converted to a number |
| NA | Returns the error value #N/A |
| NETWORKDAYS | Returns the number of whole workdays between two dates |
| NOT | Reverses the logic of its argument |
| NOW | Returns the serial number of the current date and time |
| ODD | Rounds a number up to the nearest odd integer |
| OR | Returns TRUE if any argument is TRUE |
| PERMUT | Returns the number of permutations for a given number of objects |
| PI | Returns the value of Pi |
| POWER | Returns the result of a number raised to a power |
| PRODUCT | Multiplies its arguments |
| PROPER | Capitalises the first letter in each word of a text value |
| QUARTILE | Returns the quartile of a data set |
| QUOTIENT | Returns the integer portion of a division |
| RAND | Returns a random number between 0 and 1 |
| RANDBETWEEN | Returns a random number between the numbers you specify |
| RANK | Returns the rank of a number in a list of numbers |
| REPLACE | Replaces characters within text |
| REPT | Repeats text a given number of times |
| RIGHT | Returns the rightmost characters from a text value |
| ROMAN | Converts an arabic numeral to roman, as text |
| ROUND | Rounds a number to a specified number of digits |
| ROUNDDOWN | Rounds a number down, toward zero |
| ROUNDUP | Rounds a number up, away from zero |
| SECOND | Converts a serial number to a second |
| SIGN | Returns the sign of a number |
| SLN | Returns the straight-line depreciation of an asset for one period |
| SMALL | Returns the k-th smallest value in a data set |
| STDEV | Estimates standard deviation based on a sample |
| STDEVP | Calculates standard deviation based on the entire population |
| SUBSTITUTE | Substitutes new text for old text in a text string |
| SUBTOTAL | Returns a subtotal in a list or database |
| SUM | Adds its arguments |
| SUM_as_Running_Total | Sample |
| SUM_using_names | Using SUM(jan) |
| SUM_with_OFFSET | Sample |
| SUMIF | Adds the cells specified by a given criteria |
| SUMPRODUCT | Returns the sum of the products of corresponding array components |
| SYD | Returns the sum-of-years’ digits depreciation of an asset for a specified period |
| T | Converts its arguments to text |
| TEXT | Formats a number and converts it to text |
| TIME | Returns the serial number of a particular time |
| -Timesheet | Sample |
| TIMEVALUE | Converts a time in the form of text to a serial number |
| TODAY | Returns the serial number of today’s date |
| TRANSPOSE | Returns the transpose of an array |
| TREND | Returns values along a linear trend |
| TRIM | Removes spaces from text |
| TRUNC | Truncates a number to an integer |
| TYPE | Returns a number indicating the data type of a value |
| UPPER | Converts text to uppercase |
| VALUE | Converts a text argument to a number |
| VAR | Estimates variance based on a sample |
| VARP | Calculates variance based on the entire population |
| VLOOKUP | Looks in the first column of an array and moves across the row to return the value of a cell |
| WEEKDAY | Converts a serial number to a day of the week |
| WORKDAY | Returns the serial number of the date before or after a specified number of workdays |
| YEAR | Converts a serial number to a year |
| YEARFRAC | Returns the year fraction representing the number of whole days between start_date and end_date |
Peter Noneley telah menyiapkannya untuk Anda gratis silkan kunjungi websitenya di http://www.xlfdic.com atau download di sini.
Semoga bermanfaat.
Tidak ada komentar:
Posting Komentar