ABS(number) | Returns the absolute value of a number |
ACCRINT(issue, first, settlement, rate, par, frequency, basis) | Returns the accrued interest for a security that pays periodic interest |
ACOS(number) | Returns the arccosine of a number |
ACOSH(number) | Returns the inverse hyperbolic cosine of a number |
ACOT(number) | Returns the arccotangent of a number |
ACOTH(number) | Returns the hyperbolic arccotangent of a number |
ADD(num1, num2) | Returns the sum of two given numbers |
AND(arg_1, arg_2, ..., arg_N) | Returns TRUE if all of its arguments are TRUE |
ARABIC(text) | Converts a Roman number to Arabic, as a number |
ASIN(number) | Returns the arcsine of a number |
ASINH(number) | Returns the inverse hyperbolic sine of a number |
ATAN(number) | Returns the arctangent of a number |
ATAN2(number_x, number_y) | Returns the arctangent from x- and y-coordinates |
ATANH(number) | Returns the inverse hyperbolic tangent of a number |
AVERAGE(param1,param2..) | Returns the average of its arguments |
BASE(number, radix, min_length) | Converts a number into a text representation with the given radix (base) |
BIN2DEC(number) | Converts a binary number to decimal |
BIN2HEX(number, places) | Converts a binary number to hexadecimal |
BIN2OCT(number, places) | Converts a binary number to octal |
BITAND(number1, number2) | Returns a ‘Bitwise And’ of two numbers |
BITLSHIFT(number, shift) | Returns a value number shifted left by shift_amount bits |
BITOR(number1, number2) | Returns a bitwise OR of 2 numbers |
BITRSHIFT(number, shift) | Returns a value number shifted right by shift_amount bits |
BITXOR(number1, number2) | Returns a bitwise ‘Exclusive Or’ of two numbers |
CEILING(number, significance, mode) | Rounds a number to the nearest integer or to the nearest multiple of significance |
CHAR(number) | Returns the character specified by the code number |
CLEAN(text) | Removes all nonprintable characters from text |
CODE(text) | Returns a numeric code for the first character in a text string |
COMBIN(number, number_chosen) | Returns the number of combinations for a given number of objects |
COMPLEX(real, imaginary, suffix) | Converts real and imaginary coefficients into a complex number |
CONCATENATE(param1,param2...) | Joins several text items into one text item |
CONVERT(number, from_unit, to_unit) | Converts a number from one measurement system to another |
COS(number) | Returns the cosine of a number |
COSH(number) | Returns the hyperbolic cosine of a number |
COT(number) | Returns the hyperbolic cosine of a number |
COTH(number) | Returns the cotangent of an angle |
CSC(number) | Returns the cosecant of an angle |
CSCH(number) | Returns the hyperbolic cosecant of an angle |
DATE(year, month, day) | Returns the serial number of a particular date |
DATEVALUE(date_text) | Converts a date in the form of text to a serial number |
DAY(date_serial) | Converts a serial number to a day of the month |
DAYS(end_date, start_date) | Returns the number of days between two dates |
DAYS360(start_date, end_date, method) | Calculates the number of days between two dates based on a 360-day year |
DEC2BIN(number, places) | Converts a decimal number to binary |
DEC2HEX(number, places) | Converts a decimal number to hexadecimal |
DEC2OCT(number, places) | Converts a decimal number to octal |
DECIMAL(number, radix) | Converts a text representation of a number in a given base into a decimal number |
DEGREES(number) | Converts radians to degrees |
DELTA(number1, number2) | Tests whether two values are equal |
DIVIDE(num1, num2) | Returns the results of num1 divided by num2 |
E() | Euler’s number 2.71828 |
EDATE(start_date, months) | Returns the serial number of the date that is the indicated number of months before or after the start date |
EOMONTH(start_date, months) | Returns the serial number of the last day of the month before or after a specified number of months |
EQ(val1, val2) | Returns TRUE if val1 is equal to val2 |
EVEN(number) | Rounds a number up to the nearest even integer |
EXACT(text1, text2) | Checks to see if two text values are identical |
EXP(number) | ReturnsĀ eĀ raised to the power of a given number |
EXTRACTEMAIL(inputstring,email_instance) | Returns all emails within a text |
FACT(number) | Returns the factorial of a number |
FACTDOUBLE(number) | Returns the double factorial of a number |
FIND(find_text, within_text, position) | Finds one text value within another (case-sensitive) |
FIRSTDATEOFWEEK(date_serial) | Returns the First Date of the Week |
LASTDATEOFWEEK(date_serial) | Returns the Last Date of the Week |
FIRSTDATEOFMONTH(date_serial) | Returns the First Date of the Month |
LASTDATEOFMONTH(date_serial) | Returns the Last Date of the Month |
FIRSTDATEOFTRIMESTER(date_serial) | Returns the First Date of the Trimester |
LASTDATEOFTRIMESTER(date_serial) | Returns the Last Date of the Trimester |
FIRSTDATEOFQUARTER(date_serial) | Returns the First Date of the Quarter |
LASTDATEOFQUARTER(date_serial) | Returns the Last Date of the Quarter |
FIRSTDATEOFYEAR(date_serial) | Returns the First Date of the Year |
LASTDATEOFYEAR(date_serial) | Returns the Last Date of the Year |
FLOOR(number, significance) | Rounds a number down, toward zero |
GCD(param1,param2,...) | Returns the greatest common divisor |
GEOMEAN(param1,param2,...) | Returns the geometric mean |
HARMEAN(param1,param2,...) | Returns the harmonic mean |
HEX2BIN(number, places) | Converts a hexadecimal number to binary |
HEX2DEC(number) | Converts a hexadecimal number to decimal |
HEX2OCT(number, places) | Converts a hexadecimal number to octal |
HOUR(date_serial) | Converts a serial number to an hour |
IF(logical_expression, value_if_true, value_if_false) | Specifies a logical test to perform |
IFBLANK(value,value_if_blank) | Returns value_if_blank if the value is TRUE else return value |
IFERROR(value,value_if_error) | Returns value_if_error if the value is error |
IFVALUE(logical_text,value,if_true) | Returns if_true if the logical_text is TRUE else return the true value |
IMAGINARY(inumber) | Returns the imaginary coefficient of a complex number |
IMCONJUGATE(inumber) | Returns the complex conjugate of a complex number |
IMCOS(inumber) | Returns the cosine of a complex number |
IMCOSH(inumber) | Returns the hyperbolic cosine of a complex number |
IMCOT(inumber) | Returns the cotangent of a complex number |
IMCSC(complex number) | Returns the cosecant of a complex number |
IMCSCH(complex number) | Returns the hyperbolic cosecant of a complex number |
IMDIV(inumber1, inumber2) | Returns the quotient of two complex numbers |
IMEXP(inumber) | Returns the exponential of a complex number |
IMLN(inumber) | Returns the natural logarithm of a complex number |
IMLOG10(inumber) | Returns the base-10 logarithm of a complex number |
IMLOG2(inumber) | Returns the base-2 logarithm of a complex number |
IMPOWER(inumber, number) | Returns a complex number raised to an integer power |
IMPRODUCT(inumber1,inumber2) | Returns the product of complex numbers |
IMREAL(inumber) | Returns the real coefficient of a complex number |
IMSEC(inumber) | Returns the secant of a complex number |
IMSECH(inumber) | Returns the hyperbolic secant of a complex number |
IMSIN(inumber) | Returns the sine of a complex number |
IMSINH(inumber) | Returns the hyperbolic sine of a complex number |
IMSQRT(inumber) | Returns the square root of a complex number |
IMSUB(inumber1, inumber2) | Returns the difference between two complex numbers |
IMSUM(inumber1, inumber2) | Returns the difference between two complex numbers |
IMTAN(inumber) | Returns the tangent of a complex number |
INT(number) | Rounds a number down to the nearest integer |
ISBINARY(number) | Returns true if value is in the binary number system (eg |
ISBLANK(value) | Returns TRUE if the value is blank |
ISEVEN(number) | Returns TRUE if the number is even |
ISERR(value) | Returns TRUE if the value is error other than N/A |
ISERROR(value) | Returns TRUE if the value is error |
ISLOGICAL(value) | Returns TRUE if the value is a logical value |
ISNA(value) | Returns TRUE if the value is NA |
ISNONTEXT(value) | Returns TRUE if the value is not text |
ISNUMBER(value) | Returns TRUE if the value is a number |
ISODD(number) | Returns TRUE if the number is odd |
ISOWEEKNUM(date) | Returns the number of the ISO week number of the year for a given date |
ISTEXT(value) | Returns TRUE if the value is text |
LCM(number1,number2,...) | Returns the least common multiple |
LEFT(text, number) | Returns the leftmost characters from a text value |
LEN(text) | Returns the number of characters in a text string |
LN(number) | Returns the natural logarithm of a number |
LOG(number, base) | Returns the logarithm of a number to a specified base |
LOG10(number) | Returns the base-10 logarithm of a number |
LOWER(text) | Converts text to lowercase |
MAX(number1,number2,...) | Returns the maximum value in a list of arguments |
MID(text, start, number) | Returns a specific number of characters from a text string starting at the position you specify |
MIN(number1,number2,...) | Returns the minimum value in a list of arguments |
MINUS(num1, num2) | Returns the results of num1 minus num2 |
MINUTE(date_serial) | Converts a serial number to a minute |
MOD(dividend, divisor) | Returns the remainder from division |
MONTH(date_serial) | Converts a serial number to a month |
QUARTER(date_serial) | Converts a serial number to a quarter |
MROUND(number, multiple) | Returns a number rounded to the desired multiple |
MULTIPLY(num1, num2) | Returns the result of num1 multiplied by num2 |
NETWORKDAYS(start_date, end_date, holidays) | Returns the number of whole workdays between two dates, assuming Saturday and Sunday are none working days |
NETWORKDAYS.INTL(start_date, end_date, weekend_type, holidays) | Returns the number of whole workdays between two dates |
NOT(logical) | Reverses the logic of its argument |
NOW() | Returns the serial number of the current date and time |
OCT2BIN(number, places) | Converts an octal number to binary |
OCT2DEC(number) | Converts an octal number to decimal |
OCT2HEX(number, places) | Converts an octal number to hexadecimal |
ODD(number) | Rounds a number up to the nearest odd integer |
OR(param1,param2,...) | Returns TRUE if any argument is TRUE |
PERMUTATIONA(number, number_chosen) | Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects |
PI() | Returns the value of pi |
POWER(number, power) | Returns the result of a number raised to a power |
PRODUCT(number1,number2,...) | Multiplies its arguments |
PROPER(text) | Capitalizes the first letter in each word of a text value |
QUOTIENT(numerator, denominator) | Returns the integer portion of a division |
RADIANS(number) | Converts degrees to radians |
RAND() | Returns a random number between 0 and 1 |
RANDBETWEEN(bottom, top) | Returns a random number between the numbers you specify |
REPLACE(text, position, length, new_text) | Replaces characters within text |
REPT(text, number) | Repeats text a given number of times |
RIGHT(text, number) | Returns the rightmost characters from a text value |
ROMAN(number) | Converts an arabic numeral to roman, as text |
ROUND(number, digits) | Rounds a number to a specified number of digits |
ROUNDDOWN(number, digits) | Rounds a number down, toward zero |
ROUNDUP(number, digits) | Rounds a number up, away from zero |
SEARCH(find_text, within_text, position) | Finds one text value within another (not case-sensitive) |
SEC(number) | Returns the secant of an angle |
SECH(number) | Returns the hyperbolic secant of an angle |
SECOND(date_serial) | Converts a serial number to a second |
SIGN(number) | Returns the sign of a number |
SIN(number) | Returns the sine of the given angle |
SINH(number) | Returns the hyperbolic sine of a number |
SQRT(number) | Returns a positive square root |
SQRTPI(number) | Returns the square root of (number * pi) |
SUBSTITUTE(text, old_text, new_text, occurrence) | Substitutes new text for old text in a text string |
SUM(param1,param2..) | Adds its arguments |
SUMSQ(number1,number2,...) | Returns the sum of the squares of the arguments |
T(value) | Converts its arguments to text |
TAN(number) | Returns the tangent of a number |
TANH(number) | Returns the hyperbolic tangent of a number |
TBILLEQ(settlement, maturity, discount) | Returns the bond-equivalent yield for a Treasury bill |
TIME(hour, minute, second) | Returns the serial number of a particular time |
TIMEVALUE(time_text) | Converts a time in the form of text to a serial number |
TODAY() | Returns the serial number of today’s date |
TRIM(text) | Removes spaces from text |
TRUNC(number, digits) | Truncates a number to an integer |
UNICHAR(number) | Returns the Unicode character that is references by the given numeric value |
UNICODE(text) | Returns the number (code point) that corresponds to the first character of the text |
UPPER(text) | Converts text to uppercase |
WEEKDAY(date_serial, return_type) | Converts a serial number to a day of the week |
WEEKNUM(date_serial, return_type) | Converts a serial number to a number representing where the week falls numerically with a year |
WORKDAY(start_date, days, holidays) | Returns the serial number of the date before or after a specified number of workdays, assuming Saturday and Sunday are none working days |
WORKDAY.INTL(start_date, days, weekend_type, holidays) | Returns the serial number of the date before or after a specified number of workdays |
XOR(param1,param2,...) | Returns a logical exclusive OR of all arguments |
YEAR(date_serial) | Converts a serial number to a year |
YEARFRAC(start_date, end_date, basis) | Returns the year fraction representing the number of whole days between start_date and end_date |
FALSE | Returns FALSE |
TRUE | Returns TRUE |