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.

EnglishSpanishDescription
ABSABS Returns the absolute value of a number
=ABS(number)
ACOSACOSReturns the inverse cosine of a number
=ACOS(number)
ACOSHACOSHReturns the inverse hyperbolic cosine of a number
=ACOSH(number)
ANDYReturns “TRUE” if all its arguments are “TRUE”
=AND(logical1, [logical2], …)
ASINASENOReturns the inverse sine of a number
=ASIN(number)
ASINHASENOHReturns the inverse hyperbolic sine of a number
=ASINH(number)
ATANATANReturns the inverse tangent of a number
=ATAN(number)
ATANHATANHReturns the inverse hyperbolic tangent of a number
=ATANH(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
=COS(number)
COSHCOSHReturns the hyperbolic cosine of a number
=COSH(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
=COUNTBLANK(range)
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
=DATEVALUE(date_text)
DAYDIAConverts a serial number to a day of the month value of the current year (can be leap or not)
=DAY(serial_number)
DEC2BINDEC.A.BINConvert from integer to binary number
=DEC2BIN(number, [places])
DEGREESGRADOSConvert from degrees to radians
=DEGREES(angle)
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
=EXP(number)
FACTFACTReturns the factorial of a number
=FACT(number)
FALSEFALSOReturns the logical value “FALSE”
=FALSE()
HLOOKUPBUSCARHSearches the top row of an array and returns the value of the indicated cell
=HLOOKUP(lookup_value,
table_array, row_index_num,
[range_lookup])
HOURHORAConverts a serial number to a time value
=HOUR(serial_number)
HYPERLINKHIPERVINCULOCreates a shortcut or jump that opens a document stored on a network server or on the Internet
=HYPERLINK(link_location,
[friendly_name])
IFSISpecify a logic test to perform
=IF(logical_test, [value_if_true],
[value_if_false])
IMAGINARYIMAGINARIOReturns the imaginary coefficient of a complex number
=IMAGINARY(inumber)
INFOINFOReturns information about the operating environment in use
=INFO(type_text)
INTENTEROReturns the integer part of a number
=INT(number)
ISODDES.IMPARReturns “TRUE” if the number is odd
=ISODD(number)
ISTEXTESTEXTOReturns “TRUE” if the value is text
=ISTEXT(value)
LNLNReturns the natural logarithm of a number
=LN(number)
LOGLOGReturns the logarithm of a number to a specified base
=LOG(number, [base])
LOG10LOG10Returns the base-10 logarithm of a number
=LOG10(number)
LOOKUPBUSCARReturns values from a vector or matrix
=LOOKUP(lookup_value, lookup_vector, [result_vector])
=LOOKUP(lookup_value, array)
LOWERMINUSCLowercase text
=LOWER(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
=MINUTE(serial_number)
MODEMODAReturns the most common value of a set of numbers
=MODE(number1, [number2], …)
MONTHMESConverts a serial number to a month value
=MONTH(serial_number)
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
=NOT(logical)
ODDREDONDEA.IMPARRound a number to the nearest odd integer
=ODD(number)
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)
=PI()
POWERPOTENCIAReturns the result of raising a number to a power
=POWER(number, power)
RADIANSRADIANESConvert degrees to radians
=RADIANS(angle)
RANDALEATORIOReturns a random decimal number between 0 and 1
=RAND()
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)
ROUNDDOWNREDONDEAR.MENOSRound a number down
=ROUNDDOWN(number, num_digits)
ROUNDUPREDONDEAR.MASRound a number up
=ROUNDUP(number, num_digits)
ROWFILAReturns the row number of a selected cell
=ROW([reference])
ROWSFILASReturns the number of rows in an array of selected cells
=ROWS(array)
SIGNSIGNOReturns the sign of a number such as -1 or 1
=SIGN(number)
SINSENOReturns the sine of a number in radians
=SIN(number)
SINHSENOHReturns the hyperbolic sine of a number
=SINH(number)
SQRTRAÍZReturns a positive square root of a number
=SQRT(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,
[sum_range])
TANTANReturns the tangent of a number in radians
=TAN(number)
TANHTANHReturns the hyperbolic tangent of a number
=TANH(number)
TEXTTEXTOFormats a number and converts it to text
=TEXT(value, format_text)
TODAYHOYReturns the serial number corresponding to the current day
=TODAY()
TRUEVERDADEROReturns the logical value “TRUE”
=TRUE()
UPPERMAYUSCCapitalize text
=UPPER(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
=VLOOKUP(lookup_value,
table_array, col_index_num,
[range_lookup])
WEEKDAYDIASEMConverts a serial number to a day of the week value
=WEEKDAY(serial_number,
[return_type])
YEARAÑOConverts a serial number to a year value
=YEAR(serial_number)

Thank you for being in this moment with us : )

Configurar