Functions
Speech4Excel Functions
Date/Time Function
Describtion
Date
Returns a date, from a user-supplied year, month and day
Date value
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
Days 360
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
Math Function
Describtion
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 up, away from zero
ROUNDUP
Returns a date, from a user-supplied year, month and day
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
Describtion
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
Describtion
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
Describtion
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
ISFORMULAR
Tests if a supplied cell contains a formula and if so, returns TRUE; otherwise, returns FALSE