| Fonctions de Pocket Excel |
|
copie du site Casio
|
|
|
|
| DDB (cost, salvage, life, period, factor) | Returns the depreciation of an asset for a specified period using the double declining balance method or some other method you specify. |
| FV (rate, nper, pmt, pv, type) | Returns the future value of an investment. |
| IRR ( values, guess) | Returns the internal rate of return for a series of cash flows. |
| NPER (rate, pmt, pv, fv, type) | Returns the number of periods for an investment. |
| NPV (rate, value1, value2,...) | Returns the net present value of an investment based on a series of periodic cash flows and a discount rate. |
| PMT (rate, nper, pv, fv, type) | Returns the periodic payment for an annuity. |
| PV (rate, nper, pmt, fv, type) | Returns the present value of an investment. |
| RATE (nper, pmt, pv, fv, type, guess) | Returns the interest rate per period of an annuity. |
| SLN (cost, salvage, life) | Returns the straight-line depreciation of an asset for one period. |
| SYD (cost, salvage, life, per) | Returns the sum-of-year's digits depreciation of an asset for a specific period. |
|
|
|
| DATE (year, month, day) | Returns the serial number of a particular date. |
| DATEVALUE (date, text) | Converts a date in the form of text to a serial number. |
| DAY (serial_number) | Converts a serial number to a day of the month. |
| HOUR (serial_number) | Converts a serial number to an hour. |
| MINUTE (serial_number) | Converts a serial number to a minute. |
| MONTH (serial_number) | Converts a serial number to a month. |
| NOW() | Returns the serial number of the current date and time. |
| SECOND (serial_number) | Converts a serial number to a second. |
| TIME (hour, minute, second) | Returns the serial number of a particular time. |
| TIMEVALUE (time_text) | Converts a time in the form of text to a serial number. |
| YEAR (serial_number) | Converts a serial number to a year. |
|
|
|
| ABS (number) | Returns the absolute value of a number. |
| ACOS (number) | Returns the arccosine of a number. |
| ASIN (number) | Returns the arcsine of a number. |
| ATAN (number) | Returns the arctangent of a number. |
| ATAN2 (x_num, y_num) | Returns the arctangent from x and y coordinates. |
| COS (number) | Returns the cosine of an angle. |
| COUNTIF (range, criteria) | Counts the number of non blank cells within a given range that meet the given criteria. |
| DEGREES (angle) | Converts radians to degrees. |
| EXP (number) | Returns e raised to the powwer of a given number. |
| FACT (number) | Returns the factorial of a number. |
| INT (number) | Rounds a number down to the nearest integer. |
| LN (number) | Returns the natural logarithm of a number. |
| LOG (number, base) | Returns the logarithm of a number to a specified base. |
| LOG10 (number) | Returns the base 10 logarithm of a number. |
| MOD (number, divisor) | Returns the remainder from division. |
| PI() | Returns the value of pi. |
| POWER (number, power) | Returns the result of a number raised to a power. |
| PRODUCT (number1, number2,...) | Multiplies its arguments. |
| RADIANS (angle) | Converts degrees to radians. |
| RAND() | Returns a random number between 0 and 1. |
| ROUND (number, num_digits) | Rounds a number to a specified number of digits. |
| SIN (number) | Returns the sine of the given angle. |
| SQRT (number) | Returns a positive square root. |
| SUM (number1, number2,...) | Add its arguments. |
| SUMIF (range, criteria, sum_range) | Adds the cells specified by a given criteria. |
| TAN (number) | Returns the tangent of a number. |
| TRUNC (number, num_digits) | Truncates a number to an integer. |
|
|
|
| AVERAGE (number1, number2,...) | Returns the average of its arguments. |
| COUNT (value1, value2,...) | Counts how many numbers are in the list of arguments. |
| COUNTA (value1, value2,...) | Counts how many values are in the list of arguments. |
| COUNTBLANK (range) | Counts the number of blank cells within a range. |
| MAX (number1, number2,...) | Returns the maximum value in a list of arguments. |
| MIN (number1, number2,...) | Returns the minimum value in a list of arguments. |
| STDEV (number1, number2,...) | Estimates standard deviation based on a sample. |
| STDEVP (number1, number2,...) | Calculates the standard deviation based on the entire population. |
| VAR (number1, number2,...) | Estimates variance based on a sample. |
| VARP (number1, number2,...) | Calculates variance based on the entire population. |
|
|
|
| CHOOSE (index_num, value1, value2,...) | Chooses a value from a list of values. |
| COLUMNS (array) | Returns the number of columns in a reference. |
| HLOOKUP (lookup_value, table_array, row_index_num,...) | Looks in the top row of an array and returns the value of the indicated cell. |
| INDEX (reference, row_num, column_num) | Uses an index to choose a value from a reference. |
| MATCH (lookup_value, lookup_reference, match_type) | Looks up values in a reference. |
| ROWS (array) | Returns the number of rows in a reference. |
| VLOOKUP (lookup_value, table_array, col_index_num,...) | Looks in the first column of an array and moves across the row to return the value of a cell. |
|
|
|
| DAVERAGE (database, field, criteria) | Averages the values in a column in a list or database that match conditions you specify. |
| DCOUNT (database, field, criteria) | Counts the cells that contain numbers in a column in a list or database that match conditions you specify. |
| DCOUNTA (database, field, criteria) | Counts the non blank cells in a column in a list or database that match conditions you specify. |
| DGET (database, field, criteria) | Extracts a single value from a column in a list or database that matches conditions you specify. |
| DMAX (database, field, criteria) | Returns the largest number in a column in a list or database that matches conditions you specify. |
| DMIN (database, field, criteria) | Returns the smallest number in a column in a list or database that matches conditions you specify. |
| DPRODUCT (database, field, criteria) | Multiplies the values in a column in a list or database that match conditions you specify. |
| DSTDEV (database, field, criteria) | Estimates the standard deviation based on a sample, using the numbers in a column in a list or database that match conditions you specify. |
| DSTDEVP (database, field, criteria) | Calculates the standard deviation of a population based on the entire population, using the numbers in a column in a list or database that match conditions you specify. |
| DSUM (database, field, criteria) | Adds the numbers in a column in a list or database that match conditions you specify. |
| DVAR (database, field, criteria) | Estimates variance based on a sample, using the numbers in a column in a list or database that match conditions you specify. |
| DVARP (database, field, criteria) | Calculates the variance of a population based on the entire population, using the numbers in a column in a list or database that match conditions you specify. |
|
|
|
| EXACT (text1, text2) | Checks to see if two text values are identical. |
| FIND (find_text, within_text, start_num) | Finds one text value within another (case-sensitive) |
| LEFT (text, num_chars) | Returns the leftmost characters from a text value. |
| LEN (text) | Returns the number of characters in a text string. |
| LOWER (text) | Converts text to lowercase. |
| MID (text, start_num, num_chars) | Returns a specific number of characters from a text string. |
| PROPER (text) | Capitalises the first letter in each word of a text value. |
| REPLACE (old_text, start_num, num_chars, new_text) | Replaces characters within text. |
| REPT (text, number_times) | Repeats text a given number of times. |
| RIGHT (text, num_chars) | Returns the rightmost characters from a text value. |
| SUBSTITUTE (text, old_text, new_text, instance_num) | Substitutes new text for old text in a text string. |
| T (value) | Converts its aruments to text. |
| TRIM (text) | Removes spaces from text. |
| UPPER (text) | Converts text to uppercase. |
| VALUE (text) | Converts a text argument to a number. |
|
|
|
| AND (logical1, logical2,...) | Returns TRUE if all of its arguments are TRUE. |
| FALSE() | Returns the logical value FALSE. |
| IF (logical_test, value_if_true, value_if_false) | Returns one value if logical test evaluates to TRUE, and another value if it evaluates to FALSE. |
| NOT (logical) | Reverses the logic of its argument. |
| OR (logical1, logical2,...) | Returns TRUE if any argument is TRUE. Returns FALSE if all arguments are false. |
| TRUE() | Returns the logical value TRUE. |
|
|
|
| ERROR.TYPE (error_val) | Returns a number corresponding to an error type. |
| ISBLANK (value) | Returns TRUE if the value is blank. |
| ISERR (value) | Returns TRUE if the value is any error except #N/A. |
| ISERROR (value) | Returns TRUE if the value is any error value. |
| ISLOGICAL (value) | Returns TRUE if the value is a logical value. |
| ISNA (value) | Returns TRUE if the value is the #N/A error value. |
| ISNONTEXT (value) | Returns TRUE if the value is not text. |
| ISNUMBER (value) | Returns TRUE if the value is a number. |
| ISTEXT (value) | Returns TRUE if the value is text. |
| N (value) | Returns a value converted to a number. |
| NA() | Returns the error value #N/A. |