# Speech4Excel Functions

Date/Time Function | Description |
---|---|

DATE | Returns a date, from a user-supplied year, month and day |

DATEVALUE | Converts a text string showing a date, to an integer that represents the date in Excel's date-time code |

DAY | Returns the day (of the month) for a given date |

DAYS | Calculates the number of days between 2 dates |

DAYS360 | Calculates the number of days between 2 dates, based on a 360-day year (12 x 30 months) |

HOUR | Returns the hour part of a user-supplied time |

MINUTE | Returns the minute part of a user-supplied time |

MONTH | Returns the month from a user-supplied date |

NOW | Returns the current date & time |

SECOND | Returns the seconds part of a user-supplied time |

TIME | Returns a time, from a user-supplied hour, minute and second |

TIMEVALUE | Converts a text string showing a time, to a decimal that represents the time in Excel |

TODAY | Returns today's date |

WEEKDAY | Returns an integer representing the day of the week for a supplied date |

YEAR | Returns the year from a user-supplied date |

Math Function | Description |
---|---|

ABS | Returns the absolute value of a number |

ACOS | Returns the arccosine of a number |

ACOT | Returns the arc cotangent of a number, in radians in the range 0 to Pi |

ASIN | Returns the arcsine of a number |

ATAN | Returns the arctangent of a number |

ATAN2 | Returns the arctangent from x- and y-coordinates |

BASE | Converts number into text representation |

CEILING | Rounds a number to the nearest integer or to the nearest multiple of significance |

COS | Returns the cosine of a number |

COT | Returns the cotangent of an angle |

CSC | Returns the cosecant of an angle |

DECIMAL | Converts text representation of a number in a given base into decimal number |

DEGREES | Converts radians to degrees |

EVEN | Rounds a number up to the nearest even integer |

EXP | Returns e raised to the power of a given number |

FACT | Returns the factorial of a number |

FLOOR | Rounds a number down, toward zero |

INT | Rounds a number down to nearest integer |

ISEVEN | Returns true if the number is even |

LN | Returns the natural logarithm of a number |

LOG | Returns the logarithm of a number to a specified base |

MOD | Returns the remainder from division |

MROUND | Returns a number rounded to the desired multiple |

ODD | Rounds a number up to the nearest odd integer |

POW | Returns the result of a number raised to a power |

POWER | Returns the result of a number raised to a power |

PRODUCT | Multiplies its arguments |

QUOTIENT | Returns the integer portion of a division |

RADIANS | Converts degrees to radians |

RAND | Returns an evenly distributed random number >= 0 and < 1 |

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 |

SIGN | Returns the sign of a number |

SIN | Returns the sine of the given angle |

SQRT | Returns a positive square root |

SUM | Adds its arguments |

SUMIFS | Adds the cells specified by a given set of conditions or criteria |

SUMPRODUCT | Returns the sum of the products of corresponding array components |

TAN | Returns the tangent of a number |

TRUNCATE | Truncates a number to an integer |

Statistic Function | Description |
---|---|

AVG | Returns the average of its arguments |

CONFIDENCE | Returns the confidence interval for a population mean, using a normal distribution |

COUNT | Returns the number of numerical values in a supplied set of cells or values |

COUNTA | Returns the number of non-blanks in a supplied set of cells or values |

COUNTBLANK | Returns the number of blank cells in a supplied range |

GEOMEAN | Returns the geometric mean of a set of supplied numbers |

HARMEAN | Returns the harmonic mean of a set of supplied numbers |

MAX | Returns the maximum value in a list of arguments |

MEDIAN | Returns the median of the given numbers |

MIN | Returns the minimum value in a list of arguments |

SLOPE | Returns the slope of the linear regression line through a supplied series of x- and y-values |

STANDARDIZE | Returns a normalized value |

STDEV | Returns the standard deviation of a supplied set of values (which represent a sample of a population) |

STDEVA | Returns the standard deviation of a supplied set of values (which represent a sample of a population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 |

STDEVP | Returns the standard deviation of a supplied set of values (which represent an entire population) |

STDEVPA | Returns the standard deviation of a supplied set of values (which represent an entire population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 |

VAR | Returns the variance of a supplied set of values (which represent a sample of a population) |

VARA | Returns the variance of a supplied set of values (which represent a sample of a population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 |

VARP | Returns the variance of a supplied set of values (which represent an entire population) |

VARPA | Returns the variance of a supplied set of values (which represent an entire population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 |

WEIBULL | Returns the Weibull distribution |

Text/String Function | Description |
---|---|

CONCATENATE | Joins together two or more text strings |

FIXED | Rounds a supplied number to a specified number of decimal places, and then converts this into text |

LEFT | Returns a specified number of characters from the start of a supplied text string |

LEFTB | Returns a specified number of characters from the start of a supplied text string |

LEN | Returns the length of a supplied text string |

LOWER | Converts all characters in a supplied text string to lower case |

MID | Returns a specified number of characters from the middle of a supplied text string |

NUMBERVALUE | Converts text to a number, in a locale-independent way |

REPLACE | Replaces all or part of a text string with another string (from a user supplied position) |

RIGHT | Returns a specified number of characters from the end of a supplied text string |

RIGHTB | Returns a specified number of characters from the end of a supplied text string |

SUBSTITUTE | Substitutes all occurrences of a search text string, within an original text string, with the supplied replacement text |

TEXT | Converts a supplied value into text, using a user-specified format |

TRIM | Removes duplicate spaces, and spaces at the start and end of a text string |

UPPER | Converts all characters in a supplied text string to upper case |

VALUE | Converts a text string into a numeric value |

Information Function | Description |
---|---|

ISERROR | Checks whether the value is an error and returns true or false |

ISNUMBER | Checks whether the value is number and returns true or false |

ISLOGICAL | Checks whether a value is logical value(TRUE/FALSE) and returns true or false |

ISNA | Checks whether a value is #N/A and returns true or false |

ISERR | Checks whether the value is an error except #N/A and returns true or false |

ISBLANK | Checks whether the reference is to an empty cell and returns true or false |

ISTEXT | Checks whether the value is text and returns true or false |

ISNONTEXT | Checks whether the value is not text(blank cells are not text) and returns true or false |

ISEVEN | Returns true if number is even |

ISODD | Returns true if number is odd |

ISFORMULA | Tests if a supplied cell contains a formula and if so, returns TRUE; otherwise, returns FALSE |