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.
English | Spanish | Description |
ABS | ABS | Returns the absolute value of a number =ABS(number) |
ACOS | ACOS | Returns the inverse cosine of a number =ACOS(number) |
ACOSH | ACOSH | Returns the inverse hyperbolic cosine of a number =ACOSH(number) |
AND | Y | Returns “TRUE” if all its arguments are “TRUE” =AND(logical1, [logical2], …) |
ASIN | ASENO | Returns the inverse sine of a number =ASIN(number) |
ASINH | ASENOH | Returns the inverse hyperbolic sine of a number =ASINH(number) |
ATAN | ATAN | Returns the inverse tangent of a number =ATAN(number) |
ATANH | ATANH | Returns the inverse hyperbolic tangent of a number =ATANH(number) |
AVERAGE | PROMEDIO | Returns the average of a set of numbers =AVERAGE(number1, [number2], …) |
CONVERT | CONVERTIR | Converts a number from one measurement system to another =CONVERT(number, from_unit, to_unit) |
COS | COS | Returns the cosine of a number in radians =COS(number) |
COSH | COSH | Returns the hyperbolic cosine of a number =COSH(number) |
COUNT | CONTAR | Count how many numbers are in the argument list =COUNT(value1, [value2], …) |
COUNTA | CONTARA | Counts the cells that have any character written =COUNTA(value1, [value2], …) |
COUNTBLANK | CONTAR.BLANCO | Counts the number of blank cells in a range of cells =COUNTBLANK(range) |
COUNTIF | CONTAR.SI | Counts the number of cells, within the range, that meet the specified criteria =COUNTIF(range, criteria) |
DATE | FECHA | Returns the serial number corresponding to a specific date =DATE(year, month, day) |
DATEVALUE | FECHANUMERO | Converts a text-formatted date to a serial number value =DATEVALUE(date_text) |
DAY | DIA | Converts a serial number to a day of the month value of the current year (can be leap or not) =DAY(serial_number) |
DEC2BIN | DEC.A.BIN | Convert from integer to binary number =DEC2BIN(number, [places]) |
DEGREES | GRADOS | Convert from degrees to radians =DEGREES(angle) |
DOLLAR | MONEDA | Converts a number to text, in the currency format $ =DOLLAR(number, [decimals]) |
DVAR | BDVAR | Computes the variance from a sample of selected inputs =DVAR(database, field, criteria) |
EXACT | IGUAL | Checks if two text values are identical, returns “TRUE” if true =EXACT(text1, text2) |
EXP | EXP | Returns the Éuler number raised to the power of a given number =EXP(number) |
FACT | FACT | Returns the factorial of a number =FACT(number) |
FALSE | FALSO | Returns the logical value “FALSE” =FALSE() |
HLOOKUP | BUSCARH | Searches the top row of an array and returns the value of the indicated cell =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) |
HOUR | HORA | Converts a serial number to a time value =HOUR(serial_number) |
HYPERLINK | HIPERVINCULO | Creates a shortcut or jump that opens a document stored on a network server or on the Internet =HYPERLINK(link_location, [friendly_name]) |
IF | SI | Specify a logic test to perform =IF(logical_test, [value_if_true], [value_if_false]) |
IMAGINARY | IMAGINARIO | Returns the imaginary coefficient of a complex number =IMAGINARY(inumber) |
INFO | INFO | Returns information about the operating environment in use =INFO(type_text) |
INT | ENTERO | Returns the integer part of a number =INT(number) |
ISODD | ES.IMPAR | Returns “TRUE” if the number is odd =ISODD(number) |
ISTEXT | ESTEXTO | Returns “TRUE” if the value is text =ISTEXT(value) |
LN | LN | Returns the natural logarithm of a number =LN(number) |
LOG | LOG | Returns the logarithm of a number to a specified base =LOG(number, [base]) |
LOG10 | LOG10 | Returns the base-10 logarithm of a number =LOG10(number) |
LOOKUP | BUSCAR | Returns values from a vector or matrix =LOOKUP(lookup_value, lookup_vector, [result_vector]) =LOOKUP(lookup_value, array) |
LOWER | MINUSC | Lowercase text =LOWER(text) |
MAX | MAX | Returns the maximum value from a list of numbers =MAX(number1, [number2], …) |
MEDIAN | MEDIANA | Returns the median of the given numbers =MEDIAN(number1, [number2], …) |
MIN | MIN | Returns the minimum value of a list of numbers =MIN(number1, [number2], …) |
MINUTE | MINUTO | Converts a serial number to a minute value =MINUTE(serial_number) |
MODE | MODA | Returns the most common value of a set of numbers =MODE(number1, [number2], …) |
MONTH | MES | Converts a serial number to a month value =MONTH(serial_number) |
NETWORKDAYS | DIAS.LAB | Returns the number of all business days between Monday and Friday between two dates =NETWORKDAYS(start_day, end_day, [holidays]) |
NOT | NO | Reverses the logical value of the argument =NOT(logical) |
ODD | REDONDEA.IMPAR | Round a number to the nearest odd integer =ODD(number) |
OFFSET | DESREF | Returns a reference offset relative to a given reference =OFFSET(reference, rows, cols, [height], [width]) |
OR | O | Returns “TRUE” if any argument is “TRUE” =OR(logical1, [logical2], …) |
PERMUT | PERMUTACIONES | Returns the number of permutations of a specified number of objects =PERMUT(number, number_chosen) |
PI | PI | Returns the value of Pi (\pi) =PI() |
POWER | POTENCIA | Returns the result of raising a number to a power =POWER(number, power) |
RADIANS | RADIANES | Convert degrees to radians =RADIANS(angle) |
RAND | ALEATORIO | Returns a random decimal number between 0 and 1 =RAND() |
RANDBETWEEN | ALEATORIO.ENTRE | Returns a random integer between the specified numbers =RANDBETWEEN(bottom, top) |
REPT | REPETIR | Repeat the text a certain number of times =REPT(text, number_times) |
ROMAN | NUMERO.ROMANO | Converts an Arabic number to Roman numerals formatted as text in different ways =ROMAN(number, [form]) |
ROUND | REDONDEAR | Round a number to the specified number of decimal places =ROUND(number, num_digits) |
ROUNDDOWN | REDONDEAR.MENOS | Round a number down =ROUNDDOWN(number, num_digits) |
ROUNDUP | REDONDEAR.MAS | Round a number up =ROUNDUP(number, num_digits) |
ROW | FILA | Returns the row number of a selected cell =ROW([reference]) |
ROWS | FILAS | Returns the number of rows in an array of selected cells =ROWS(array) |
SIGN | SIGNO | Returns the sign of a number such as -1 or 1 =SIGN(number) |
SIN | SENO | Returns the sine of a number in radians =SIN(number) |
SINH | SENOH | Returns the hyperbolic sine of a number =SINH(number) |
SQRT | RAÍZ | Returns a positive square root of a number =SQRT(number) |
STDEV | DESVEST | Finds the standard deviation from a number =STDEV(number1, [number2], …) |
SUBSTITUTE | SUSTITUIR | Replace new text with old text in a text string =SUBSTITUTE(text, old_text, new_text, [instance_num]) |
SUM | SUMA | Sum a set of selected numbers =SUM(number1, [number2], …) |
SUMIF | SUMAR.SI | Sum the cells in the range that meet the specified criteria =SUMIF(range, criteria, [sum_range]) |
TAN | TAN | Returns the tangent of a number in radians =TAN(number) |
TANH | TANH | Returns the hyperbolic tangent of a number =TANH(number) |
TEXT | TEXTO | Formats a number and converts it to text =TEXT(value, format_text) |
TODAY | HOY | Returns the serial number corresponding to the current day =TODAY() |
TRUE | VERDADERO | Returns the logical value “TRUE” =TRUE() |
UPPER | MAYUSC | Capitalize text =UPPER(text) |
VAR | VAR | Calculate the variance of a sample =VAR(number1, [number2], …) |
VLOOKUP | BUSCARV | Searches 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]) |
WEEKDAY | DIASEM | Converts a serial number to a day of the week value =WEEKDAY(serial_number, [return_type]) |
YEAR | AÑO | Converts a serial number to a year value =YEAR(serial_number) |
Thank you for being in this moment with us : )