Speech recognition • Functions • Excel functions used by S4E

Speech4Excel Functions

Date/Time Functions

Description

DATEReturns a date, from a user-supplied year, month and day
DATEVALUEConverts a text string showing a date, to an integer that represents the date in Excel’s date-time code
DAYReturns the day (of the month) for a given date
DAYSCalculates the number of days between 2 dates
DAYS360Calculates the number of days between 2 dates, based on a 360-day year (12 x 30 months)
HOURReturns the hour part of a user-supplied time
MINUTEReturns the minute part of a user-supplied time
MONTHReturns the month from a user-supplied date
NOWReturns the current date & time
SECONDReturns the seconds part of a user-supplied time
TIMEReturns a time, from a user-supplied hour, minute and second
TIMEVALUEConverts a text string showing a time, to a decimal that represents the time in Excel
TODAYReturns today’s date
WEEKDAYReturns an integer representing the day of the week for a supplied date
YEARReturns the year from a user-supplied date

Math Functions

Description

ABSReturns the absolute value of a number
ACOSReturns the arccosine of a number
ACOTReturns the arc cotangent of a number, in radians in the range 0 to Pi
ASINReturns the arcsine of a number
ATANReturns the arctangent of a number
ATAN2Returns the arctangent from x- and y-coordinates
BASEConverts number into text representation
CEILINGRounds a number to the nearest integer or to the nearest multiple of significance
COSReturns the cosine of a number
COTReturns the cotangent of an angle
CSCReturns the cosecant of an angle
DECIMALConverts text representation of a number in a given base into decimal number
DEGREESConverts radians to degrees
EVENRounds a number up to the nearest even integer
EXPReturns e raised to the power of a given number
FACTReturns the factorial of a number
FLOORRounds a number down, toward zero
INTRounds a number down to nearest integer
ISEVENReturns true if the number is even
LNReturns the natural logarithm of a number
LOGReturns the logarithm of a number to a specified base
MODReturns the remainder from division
MROUNDReturns a number rounded to the desired multiple
ODDRounds a number up to the nearest odd integer
POWReturns the result of a number raised to a power
POWERReturns the result of a number raised to a power
PRODUCTMultiplies its arguments
QUOTIENTReturns the integer portion of a division
RADIANSConverts degrees to radians
RANDReturns an evenly distributed random number >= 0 and < 1
ROUNDRounds a number to a specified number of digits
ROUNDDOWNRounds a number down, toward zero
ROUNDUPRounds a number up, away from zero
SIGNReturns the sign of a number
SINReturns the sine of the given angle
SQRTReturns a positive square root
SUMAdds its arguments
SUMIFSAdds the cells specified by a given set of conditions or criteria
SUMPRODUCTReturns the sum of the products of corresponding array components
TANReturns the tangent of a number
TRUNCATETruncates a number to an integer

Statistic Functions

Description

AVGReturns the average of its arguments
CONFIDENCEReturns the confidence interval for a population mean, using a normal distribution
COUNTReturns the number of numerical values in a supplied set of cells or values
COUNTAReturns the number of non-blanks in a supplied set of cells or values
COUNTBLANKReturns the number of blank cells in a supplied range
GEOMEANReturns the geometric mean of a set of supplied numbers
HARMEANReturns the harmonic mean of a set of supplied numbers
MAXReturns the maximum value in a list of arguments
MEDIANReturns the median of the given numbers
MINReturns the minimum value in a list of arguments
SLOPEReturns the slope of the linear regression line through a supplied series of x- and y-values
STANDARDIZEReturns a normalized value
STDEVReturns the standard deviation of a supplied set of values (which represent a sample of a population)
STDEVAReturns 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
STDEVPReturns the standard deviation of a supplied set of values (which represent an entire population)
STDEVPAReturns 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
VARReturns the variance of a supplied set of values (which represent a sample of a population)
VARAReturns 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
VARPReturns the variance of a supplied set of values (which represent an entire population)
VARPAReturns 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
WEIBULLReturns the Weibull distribution

Text/String Functions

Description

CONCATENATEJoins together two or more text strings
FIXEDRounds a supplied number to a specified number of decimal places, and then converts this into text
LEFTReturns a specified number of characters from the start of a supplied text string
LEFTBReturns a specified number of characters from the start of a supplied text string
LENReturns the length of a supplied text string
LOWERConverts all characters in a supplied text string to lower case
MIDReturns a specified number of characters from the middle of a supplied text string
NUMBERVALUEConverts text to a number, in a locale-independent way
REPLACEReplaces all or part of a text string with another string (from a user supplied position)
RIGHTReturns a specified number of characters from the end of a supplied text string
RIGHTBReturns a specified number of characters from the end of a supplied text string
SUBSTITUTESubstitutes all occurrences of a search text string, within an original text string, with the supplied replacement text
TEXTConverts a supplied value into text, using a user-specified format
TRIMRemoves duplicate spaces, and spaces at the start and end of a text string
UPPERConverts all characters in a supplied text string to upper case
VALUEConverts a text string into a numeric value

Information Functions

Description

ISERRORChecks whether the value is an error and returns true or false
ISNUMBERChecks whether the value is number and returns true or false
ISLOGICALChecks whether a value is logical value(TRUE/FALSE) and returns true or false
ISNAChecks whether a value is #N/A and returns true or false
ISERRChecks whether the value is an error except #N/A and returns true or false
ISBLANKChecks whether the reference is to an empty cell and returns true or false
ISTEXTChecks whether the value is text and returns true or false
ISNONTEXTChecks whether the value is not text(blank cells are not text) and returns true or false
ISEVENReturns true if number is even
ISODDReturns true if number is odd
ISFORMULATests if a supplied cell contains a formula and if so, returns TRUE; otherwise, returns FALSE
Nach oben scrollen