Skip to content
RBJLabs ®

Excel functions

Below we list in alphabetical order the Excel functions in English and Spanish that we are most familiar with. The example of the description is written in an Excel sheet configured in English, in Spanish the writing of some function may vary. The functions that have square brackets [] in some word of their argument, it means that they are optional.

ABSABS Returns the absolute value of a number
ACOSACOSReturns the inverse cosine of a number
ACOSHACOSHReturns the inverse hyperbolic cosine of a number
ANDYReturns “TRUE” if all its arguments are “TRUE”
=AND(logical1, [logical2], …)
ASINASENOReturns the inverse sine of a number
ASINHASENOHReturns the inverse hyperbolic sine of a number
ATANATANReturns the inverse tangent of a number
ATANHATANHReturns the inverse hyperbolic tangent of a number
AVERAGEPROMEDIOReturns the average of a set of numbers
=AVERAGE(number1, [number2], …)
CONVERTCONVERTIRConverts a number from one measurement system to another
=CONVERT(number, from_unit, to_unit)
COSCOSReturns the cosine of a number in radians
COSHCOSHReturns the hyperbolic cosine of a number
COUNTCONTARCount how many numbers are in the argument list
=COUNT(value1, [value2], …)
COUNTACONTARACounts the cells that have any character written
=COUNTA(value1, [value2], …)
COUNTBLANKCONTAR.BLANCOCounts the number of blank cells in a range of cells
COUNTIFCONTAR.SICounts the number of cells, within the range, that meet the specified criteria
=COUNTIF(range, criteria)
DATEFECHAReturns the serial number corresponding to a specific date
=DATE(year, month, day)
DATEVALUEFECHANUMEROConverts a text-formatted date to a serial number value
DAYDIAConverts a serial number to a day of the month value of the current year (can be leap or not)
DEC2BINDEC.A.BINConvert from integer to binary number
=DEC2BIN(number, [places])
DEGREESGRADOSConvert from degrees to radians
DOLLARMONEDAConverts a number to text, in the currency format $
=DOLLAR(number, [decimals])
DVARBDVARComputes the variance from a sample of selected inputs
=DVAR(database, field, criteria)
EXACTIGUALChecks if two text values are identical, returns “TRUE” if true
=EXACT(text1, text2)
EXPEXPReturns the Éuler number raised to the power of a given number
FACTFACTReturns the factorial of a number
FALSEFALSOReturns the logical value “FALSE”
HLOOKUPBUSCARHSearches the top row of an array and returns the value of the indicated cell
table_array, row_index_num,
HOURHORAConverts a serial number to a time value
HYPERLINKHIPERVINCULOCreates a shortcut or jump that opens a document stored on a network server or on the Internet
IFSISpecify a logic test to perform
=IF(logical_test, [value_if_true],
IMAGINARYIMAGINARIOReturns the imaginary coefficient of a complex number
INFOINFOReturns information about the operating environment in use
INTENTEROReturns the integer part of a number
ISODDES.IMPARReturns “TRUE” if the number is odd
ISTEXTESTEXTOReturns “TRUE” if the value is text
LNLNReturns the natural logarithm of a number
LOGLOGReturns the logarithm of a number to a specified base
=LOG(number, [base])
LOG10LOG10Returns the base-10 logarithm of a number
LOOKUPBUSCARReturns values from a vector or matrix
=LOOKUP(lookup_value, lookup_vector, [result_vector])
=LOOKUP(lookup_value, array)
LOWERMINUSCLowercase text
MAXMAXReturns the maximum value from a list of numbers
=MAX(number1, [number2], …)
MEDIANMEDIANAReturns the median of the given numbers
=MEDIAN(number1, [number2], …)
MINMINReturns the minimum value of a list of numbers
=MIN(number1, [number2], …)
MINUTEMINUTOConverts a serial number to a minute value
MODEMODAReturns the most common value of a set of numbers
=MODE(number1, [number2], …)
MONTHMESConverts a serial number to a month value
NETWORKDAYSDIAS.LABReturns the number of all business days between Monday and Friday between two dates
=NETWORKDAYS(start_day, end_day, [holidays])
NOTNOReverses the logical value of the argument
ODDREDONDEA.IMPARRound a number to the nearest odd integer
OFFSETDESREFReturns a reference offset relative to a given reference
=OFFSET(reference, rows, cols, [height], [width])
OROReturns “TRUE” if any argument is “TRUE”
=OR(logical1, [logical2], …)
PERMUTPERMUTACIONESReturns the number of permutations of a specified number of objects
=PERMUT(number, number_chosen)
PIPIReturns the value of Pi (\pi)
POWERPOTENCIAReturns the result of raising a number to a power
=POWER(number, power)
RADIANSRADIANESConvert degrees to radians
RANDALEATORIOReturns a random decimal number between 0 and 1
RANDBETWEENALEATORIO.ENTREReturns a random integer between the specified numbers
=RANDBETWEEN(bottom, top)
REPTREPETIRRepeat the text a certain number of times
=REPT(text, number_times)
ROMANNUMERO.ROMANOConverts an Arabic number to Roman numerals formatted as text in different ways
=ROMAN(number, [form])
ROUNDREDONDEARRound a number to the specified number of decimal places
=ROUND(number, num_digits)
=ROUNDDOWN(number, num_digits)
=ROUNDUP(number, num_digits)
ROWFILAReturns the row number of a selected cell
ROWSFILASReturns the number of rows in an array of selected cells
SIGNSIGNOReturns the sign of a number such as -1 or 1
SINSENOReturns the sine of a number in radians
SINHSENOHReturns the hyperbolic sine of a number
SQRTRAÍZReturns a positive square root of a number
STDEVDESVESTFinds the standard deviation from a number
=STDEV(number1, [number2], …)
SUBSTITUTESUSTITUIRReplace new text with old text in a text string
=SUBSTITUTE(text, old_text,
new_text, [instance_num])
SUMSUMASum a set of selected numbers
=SUM(number1, [number2], …)
SUMIFSUMAR.SISum the cells in the range that meet the specified criteria
=SUMIF(range, criteria,
TANTANReturns the tangent of a number in radians
TANHTANHReturns the hyperbolic tangent of a number
TEXTTEXTOFormats a number and converts it to text
=TEXT(value, format_text)
TODAYHOYReturns the serial number corresponding to the current day
TRUEVERDADEROReturns the logical value “TRUE”
UPPERMAYUSCCapitalize text
VARVARCalculate the variance of a sample
=VAR(number1, [number2], …)
VLOOKUPBUSCARVSearches the first column of an array and moves horizontally through the row to return the value of a cell
table_array, col_index_num,
WEEKDAYDIASEMConverts a serial number to a day of the week value
YEARAÑOConverts a serial number to a year value

Thank you for being in this moment with us : )