Practice Online Spreadsheet Sandbox
Practice Excel formulas, test calculations, and work on sheets directly in your browser. No software to install, and your data stays completely private on your device.
Lightning Fast
Instant Real-Time Calculations
Beginner Friendly
8 Step-by-Step Guides
Starter Sheets
3 Ready-to-Use Templates
Simple Spreadsheet Guides
Easy step-by-step guides with simple examples, practical tips, and shortcuts to help you get started.
The Complete Hands-On Guide to Using the ExcelClash Spreadsheet Editor
Master our free in-browser spreadsheet editor. Learn grid navigation, in-cell editing (F2), smart formula autocomplete, table styling, and XLSX/CSV tools.
The Complete Guide to Writing Excel Formulas from Scratch
Master spreadsheet math from zero. Learn dynamic cell references, absolute locking ($), core functions, IF logic, and error diagnosis.
The Ultimate Guide to VLOOKUP, INDEX, and MATCH in Excel
Stop searching through spreadsheet rows manually. Learn how VLOOKUP, INDEX/MATCH, and XLOOKUP pull information automatically with step-by-step examples.
15 Must-Know Spreadsheet Shortcuts to Navigate 10x Faster
Stop clicking around with your mouse. Master keyboard navigation, in-cell editing (F2), range selection, and instant recovery in Excel.
The Designer's Guide to Formatting Professional Spreadsheets in Excel
Turn messy numbers into beautiful, executive-ready tables using visual hierarchy, semantic colors, proper cell alignment, and number formatting.
The Ultimate Guide to Cleaning Dirty Data with Text Formulas in Excel
Transform messy CSV imports, strip invisible rogue spaces, fix irregular casing, and split or combine strings using essential text formulas.
The Executive Guide to Building Business Budgets and Financial Models
Construct dynamic revenue engines, categorize fixed vs variable expenses, compute profit margins, and perform sensitivity analysis in Excel.
The Master Guide to Date and Time Formulas in Excel
Master spreadsheet date arithmetic, dynamic timestamps (TODAY/NOW), project workdays (WORKDAY), milestone intervals, and DATEDIF calculations.
Excel Formulas You Can Use
Math & Numbers
83 Formulas=ABS(number)Returns the absolute value of a number, stripping any negative sign.
=ACOS(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with ACOS.
=ACOSH(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with ACOSH.
=ACOT(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with ACOT.
=ACOTH(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with ACOTH.
=ARABIC(roman_text)Converts a Roman numeral text into an Arabic integer.
=ASIN(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with ASIN.
=ASINH(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with ASINH.
=ATAN(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with ATAN.
=ATAN2(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with ATAN2.
=ATANH(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with ATANH.
=BASE(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with BASE.
=BESSELI(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with BESSELI.
=BESSELJ(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with BESSELJ.
=BESSELK(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with BESSELK.
=BESSELY(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with BESSELY.
=CEILING(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with CEILING.
=CEILING.MATH(number, [significance], [mode])Rounds a number up to the nearest integer or multiple of significance.
=CEILING.PRECISE(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with CEILING.PRECISE.
=COMBIN(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with COMBIN.
=COMBINA(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with COMBINA.
=COS(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with COS.
=COSH(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with COSH.
=COT(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with COT.
=COTH(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with COTH.
=CSC(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with CSC.
=CSCH(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with CSCH.
=DECIMAL(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with DECIMAL.
=DEGREES(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with DEGREES.
=EVEN(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with EVEN.
=EXP(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with EXP.
=FACT(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with FACT.
=FACTDOUBLE(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with FACTDOUBLE.
=FLOOR(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with FLOOR.
=FLOOR.MATH(number, [significance], [mode])Rounds a number down to the nearest integer or multiple.
=FLOOR.PRECISE(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with FLOOR.PRECISE.
=GCD(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with GCD.
=INT(number)Rounds a number down to the nearest whole integer.
=ISO.CEILING(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with ISO.CEILING.
=LCM(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with LCM.
=LN(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with LN.
=LOG(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with LOG.
=LOG10(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with LOG10.
=MDETERM(array)Calculates the matrix determinant of a square array.
=MMULT(array1, array2)Returns the matrix product of two matching arrays.
=MOD(number, divisor)Returns the remainder after a number is divided by a divisor.
=MROUND(number, multiple)Rounds a number to the nearest specified multiple.
=MULTINOMIAL(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with MULTINOMIAL.
=MUNIT(dimension)Returns the unit matrix or identity matrix of a specified dimension.
=ODD(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with ODD.
=PI()Returns the mathematical constant Pi accurate to 15 digits (3.14159...).
=POISSON(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with POISSON.
=POWER(number, power)Returns the result of a number raised to a given power.
=PRODUCT(number1, [number2], ...)Multiplies all given numbers and returns the product.
=QUOTIENT(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with QUOTIENT.
=RADIANS(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with RADIANS.
=RAND()Generates an evenly distributed random real number between 0 and 1.
=RANDBETWEEN(bottom, top)Returns a random integer between specified lower and upper bounds.
=ROMAN(number, [form])Converts an Arabic numeral to Roman text.
=ROUND(number, num_digits)Rounds a number to a specified number of decimal digits.
=ROUNDDOWN(number, num_digits)Rounds a number down, toward zero.
=ROUNDUP(number, num_digits)Rounds a number up, away from zero.
=SEC(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SEC.
=SECH(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SECH.
=SERIESSUM(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SERIESSUM.
=SIGN(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SIGN.
=SIN(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SIN.
=SINH(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SINH.
=SQRT(number)Calculates the positive square root of a number.
=SQRTPI(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SQRTPI.
=SUBTOTAL(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SUBTOTAL.
=SUM(number1, [number2], ...)Adds all numerical values across cells and ranges.
=SUMIF(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SUMIF.
=SUMIFS(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SUMIFS.
=SUMPRODUCT(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SUMPRODUCT.
=SUMSQ(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SUMSQ.
=SUMX2MY2(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SUMX2MY2.
=SUMX2PY2(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SUMX2PY2.
=SUMXMY2(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with SUMXMY2.
=TAN(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with TAN.
=TANH(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with TANH.
=TRUNC(number, [num_digits])Truncates a number to a specified precision by cutting off decimals.
=WEIBULL(...)Evaluates numerical calculations, algebra, trigonometry, or rounding with WEIBULL.
Lookup & Search
18 Formulas=ADDRESS(row_num, col_num, [abs_num])Generates a cell reference as a text string (e.g. "$B$3") from row and column numbers.
=ARRAYFORMULA(...)Searches, retrieves coordinates, filters arrays, or references dynamic cell ranges with ARRAYFORMULA.
=ARRAY_CONSTRAIN(...)Searches, retrieves coordinates, filters arrays, or references dynamic cell ranges with ARRAY_CONSTRAIN.
=COLUMN([reference])Returns the column number of a cell reference (returns 3 for column C).
=COLUMNS(array)Returns the total number of columns in a given range or array.
=FILTER(array, include, [if_empty])Filters a range or array based on defined boolean criteria.
=HLOOKUP(lookup_value, table_array, row_index, [range_lookup])Searches the top row of a table horizontally and returns a value from the specified row.
=HYPERLINK(link_location, [friendly_name])Creates a clickable shortcut or jump that opens a specified link location.
=INDEX(array, row_num, [col_num])Returns a cell value from a specified row and column coordinate.
=MATCH(lookup_value, lookup_array, [match_type])Finds the relative numeric position of an item in a single column or row range.
=OFFSET(reference, rows, cols, [height], [width])Returns a cell or range offset from a starting reference by a given distance.
=ROW([reference])Returns the row number of a cell reference (returns 5).
=ROWS(array)Returns the total number of rows in a given range or array.
=SHEET(...)Searches, retrieves coordinates, filters arrays, or references dynamic cell ranges with SHEET.
=SHEETS(...)Searches, retrieves coordinates, filters arrays, or references dynamic cell ranges with SHEETS.
=TRANSPOSE(array)Flips the orientation of a given range from vertical to horizontal or vice versa.
=VLOOKUP(lookup_value, table_array, col_index, [range_lookup])Searches the first column of a table and retrieves a matching value from another column.
=XLOOKUP(lookup_val, lookup_arr, return_arr, [if_not_found])Modern exact-match lookup searching in any direction with built-in error handling.
Logic & Conditions
12 Formulas=AND(logical1, [logical2], ...)Returns TRUE if all provided conditions evaluate to TRUE.
=CHOOSE(index_num, value1, [value2], ...)Uses an index number to return a selected value from a list of arguments.
=FALSE(...)Evaluates logical conditions, fallback handlers, or branch routing with FALSE.
=IF(logical_test, value_if_true, value_if_false)Evaluates a condition and returns one value if TRUE and another if FALSE.
=IFERROR(value, value_if_error)Returns a custom fallback value if a formula produces an error, otherwise returns the result.
=IFNA(value, value_if_na)Returns a fallback value specifically when a formula evaluates to a #N/A error.
=IFS(logical_test1, val1, [logical_test2, val2], ...)Evaluates multiple conditions in order and returns the first matching value.
=NOT(logical)Inverts the logical boolean truth value of its argument.
=OR(logical1, [logical2], ...)Returns TRUE if any of the provided conditions evaluate to TRUE.
=SWITCH(expression, val1, result1, [val2, result2], ..., [default])Evaluates an expression against a list of clauses and returns the matching outcome.
=TRUE(...)Evaluates logical conditions, fallback handlers, or branch routing with TRUE.
=XOR(logical1, [logical2], ...)Returns exclusive OR logical comparison across conditions.
Text & Words
29 Formulas=CHAR(number)Returns the character specified by the ANSI code number (e.g. 65 returns "A").
=CLEAN(text)Removes all non-printable ASCII characters from imported text.
=CODE(text)Returns a numeric code for the first character in a text string.
=CONCAT(text1, [text2], ...)Combines the text from multiple ranges and strings without a delimiter.
=CONCATENATE(text1, [text2], ...)Legacy function to join two or more text strings together.
=DOLLAR(number, [decimals])Formats a number as USD currency text with commas and dollar sign.
=EXACT(text1, text2)Checks if two text strings are identical with case-sensitivity.
=FIND(find_text, within_text, [start_num])Returns the character starting position of a case-sensitive substring.
=FIXED(number, [decimals], [no_commas])Formats a number as fixed-decimal text with optional thousand separators.
=LEFT(text, [num_chars])Extracts a specified number of characters from the start (left side) of a text string.
=LEFTB(text, [num_bytes])Extracts characters from the start based on the number of bytes for double-byte character sets.
=LEN(text)Returns the total count of characters in a text string.
=LENB(text)Returns the total count of bytes used to represent the characters in a text string.
=LOWER(text)Converts all letters in a text string to lowercase.
=MID(text, start_num, num_chars)Extracts characters from the middle of a text string starting at a given position.
=PROPER(text)Capitalizes the first letter of every word in a text string.
=REPLACE(old_text, start_num, num_chars, new_text)Replaces part of a text string based on character index position.
=REPT(text, number_times)Repeats text a given number of times (e.g. returns "*****").
=RIGHT(text, [num_chars])Extracts a specified number of characters from the end (right side) of a text string.
=SEARCH(find_text, within_text, [start_num])Returns the position of a substring with wildcard support (case-insensitive).
=SPLIT(text, ...)Transforms, formats, extracts substrings, joins, or cleans text with SPLIT.
=SUBSTITUTE(text, old_text, new_text, [instance_num])Replaces occurrences of existing text with new text in a string.
=TEXT(value, format_text)Formats a number or date and converts it into a formatted text string.
=TEXTJOIN(delimiter, ignore_empty, text1, ...)Combines text from multiple ranges separated by a delimiter, skipping empty cells.
=TRIM(text)Removes all leading, trailing, and duplicate spaces from text.
=UNICHAR(number)Returns the Unicode character referenced by the numeric value.
=UNICODE(text)Returns the number (code point) corresponding to the first character of the text.
=UPPER(text)Converts all letters in a text string to uppercase.
=VALUE(text)Converts a text string that represents a number into an actual numeric value.
Dates & Time
26 Formulas=DATE(...)Evaluates calendar dates, timestamps, workdays, or time intervals using DATE.
=DATEDIF(...)Evaluates calendar dates, timestamps, workdays, or time intervals using DATEDIF.
=DATEVALUE(...)Evaluates calendar dates, timestamps, workdays, or time intervals using DATEVALUE.
=DAY(...)Evaluates calendar dates, timestamps, workdays, or time intervals using DAY.
=DAYS(...)Evaluates calendar dates, timestamps, workdays, or time intervals using DAYS.
=DAYS360(...)Evaluates calendar dates, timestamps, workdays, or time intervals using DAYS360.
=EDATE(...)Evaluates calendar dates, timestamps, workdays, or time intervals using EDATE.
=EOMONTH(...)Evaluates calendar dates, timestamps, workdays, or time intervals using EOMONTH.
=HOUR(...)Evaluates calendar dates, timestamps, workdays, or time intervals using HOUR.
=INTERVAL(...)Evaluates calendar dates, timestamps, workdays, or time intervals using INTERVAL.
=ISOWEEKNUM(...)Evaluates calendar dates, timestamps, workdays, or time intervals using ISOWEEKNUM.
=MINUTE(...)Evaluates calendar dates, timestamps, workdays, or time intervals using MINUTE.
=MONTH(...)Evaluates calendar dates, timestamps, workdays, or time intervals using MONTH.
=NETWORKDAYS(...)Evaluates calendar dates, timestamps, workdays, or time intervals using NETWORKDAYS.
=NETWORKDAYS.INTL(...)Evaluates calendar dates, timestamps, workdays, or time intervals using NETWORKDAYS.INTL.
=NOW(...)Evaluates calendar dates, timestamps, workdays, or time intervals using NOW.
=SECOND(...)Evaluates calendar dates, timestamps, workdays, or time intervals using SECOND.
=TIME(...)Evaluates calendar dates, timestamps, workdays, or time intervals using TIME.
=TIMEVALUE(...)Evaluates calendar dates, timestamps, workdays, or time intervals using TIMEVALUE.
=TODAY(...)Evaluates calendar dates, timestamps, workdays, or time intervals using TODAY.
=WEEKDAY(...)Evaluates calendar dates, timestamps, workdays, or time intervals using WEEKDAY.
=WEEKNUM(...)Evaluates calendar dates, timestamps, workdays, or time intervals using WEEKNUM.
=WORKDAY(...)Evaluates calendar dates, timestamps, workdays, or time intervals using WORKDAY.
=WORKDAY.INTL(...)Evaluates calendar dates, timestamps, workdays, or time intervals using WORKDAY.INTL.
=YEAR(...)Evaluates calendar dates, timestamps, workdays, or time intervals using YEAR.
=YEARFRAC(...)Evaluates calendar dates, timestamps, workdays, or time intervals using YEARFRAC.
Counting & Statistics
142 Formulas=AVEDEV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with AVEDEV.
=AVERAGE(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with AVERAGE.
=AVERAGEA(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with AVERAGEA.
=AVERAGEIF(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with AVERAGEIF.
=AVERAGEIFS(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with AVERAGEIFS.
=BETA.DIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with BETA.DIST.
=BETA.INV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with BETA.INV.
=BETADIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with BETADIST.
=BETAINV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with BETAINV.
=BINOM.DIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with BINOM.DIST.
=BINOM.INV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with BINOM.INV.
=BINOMDIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with BINOMDIST.
=CHIDIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CHIDIST.
=CHIDISTRT(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CHIDISTRT.
=CHIINV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CHIINV.
=CHIINVRT(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CHIINVRT.
=CHISQ.DIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CHISQ.DIST.
=CHISQ.DIST.RT(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CHISQ.DIST.RT.
=CHISQ.INV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CHISQ.INV.
=CHISQ.INV.RT(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CHISQ.INV.RT.
=CHISQ.TEST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CHISQ.TEST.
=CHITEST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CHITEST.
=CONFIDENCE(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CONFIDENCE.
=CONFIDENCE.NORM(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CONFIDENCE.NORM.
=CONFIDENCE.T(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CONFIDENCE.T.
=CORREL(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CORREL.
=COUNT(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with COUNT.
=COUNTA(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with COUNTA.
=COUNTBLANK(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with COUNTBLANK.
=COUNTIF(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with COUNTIF.
=COUNTIFS(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with COUNTIFS.
=COUNTUNIQUE(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with COUNTUNIQUE.
=COVAR(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with COVAR.
=COVARIANCE.P(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with COVARIANCE.P.
=COVARIANCE.S(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with COVARIANCE.S.
=COVARIANCEP(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with COVARIANCEP.
=COVARIANCES(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with COVARIANCES.
=CRITBINOM(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with CRITBINOM.
=DEVSQ(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with DEVSQ.
=EXPON.DIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with EXPON.DIST.
=EXPONDIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with EXPONDIST.
=F.DIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with F.DIST.
=F.DIST.RT(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with F.DIST.RT.
=F.INV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with F.INV.
=F.INV.RT(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with F.INV.RT.
=F.TEST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with F.TEST.
=FDIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with FDIST.
=FDISTRT(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with FDISTRT.
=FINV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with FINV.
=FINVRT(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with FINVRT.
=FISHER(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with FISHER.
=FISHERINV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with FISHERINV.
=FTEST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with FTEST.
=GAMMA(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with GAMMA.
=GAMMA.DIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with GAMMA.DIST.
=GAMMA.INV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with GAMMA.INV.
=GAMMADIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with GAMMADIST.
=GAMMAINV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with GAMMAINV.
=GAMMALN(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with GAMMALN.
=GAMMALN.PRECISE(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with GAMMALN.PRECISE.
=GAUSS(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with GAUSS.
=GEOMEAN(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with GEOMEAN.
=HARMEAN(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with HARMEAN.
=HYPGEOM.DIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with HYPGEOM.DIST.
=HYPGEOMDIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with HYPGEOMDIST.
=LARGE(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with LARGE.
=LOGINV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with LOGINV.
=LOGNORM.DIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with LOGNORM.DIST.
=LOGNORM.INV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with LOGNORM.INV.
=LOGNORMDIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with LOGNORMDIST.
=LOGNORMINV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with LOGNORMINV.
=MAX(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with MAX.
=MAXA(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with MAXA.
=MAXIFS(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with MAXIFS.
=MAXPOOL(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with MAXPOOL.
=MEDIAN(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with MEDIAN.
=MEDIANPOOL(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with MEDIANPOOL.
=MIN(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with MIN.
=MINA(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with MINA.
=MINIFS(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with MINIFS.
=MINVERSE(array)Returns the inverse matrix for a given square matrix array.
=MODE(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with MODE.
=MODE.MULT(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with MODE.MULT.
=MODE.SNGL(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with MODE.SNGL.
=NEGBINOM.DIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with NEGBINOM.DIST.
=NEGBINOMDIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with NEGBINOMDIST.
=NORM.DIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with NORM.DIST.
=NORM.INV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with NORM.INV.
=NORM.S.DIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with NORM.S.DIST.
=NORM.S.INV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with NORM.S.INV.
=NORMDIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with NORMDIST.
=NORMINV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with NORMINV.
=NORMSDIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with NORMSDIST.
=NORMSINV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with NORMSINV.
=PEARSON(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with PEARSON.
=PERCENTILE.EXC(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with PERCENTILE.EXC.
=PERCENTILE.INC(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with PERCENTILE.INC.
=PHI(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with PHI.
=POISSON.DIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with POISSON.DIST.
=POISSONDIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with POISSONDIST.
=QUARTILE.EXC(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with QUARTILE.EXC.
=QUARTILE.INC(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with QUARTILE.INC.
=RANK.AVG(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with RANK.AVG.
=RANK.EQ(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with RANK.EQ.
=RSQ(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with RSQ.
=SKEW(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with SKEW.
=SKEW.P(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with SKEW.P.
=SKEWP(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with SKEWP.
=SLOPE(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with SLOPE.
=SMALL(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with SMALL.
=STANDARDIZE(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with STANDARDIZE.
=STDEV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with STDEV.
=STDEV.P(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with STDEV.P.
=STDEV.S(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with STDEV.S.
=STDEVA(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with STDEVA.
=STDEVP(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with STDEVP.
=STDEVPA(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with STDEVPA.
=STDEVS(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with STDEVS.
=STEYX(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with STEYX.
=T.DIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with T.DIST.
=T.DIST.2T(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with T.DIST.2T.
=T.DIST.RT(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with T.DIST.RT.
=T.INV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with T.INV.
=T.INV.2T(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with T.INV.2T.
=T.TEST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with T.TEST.
=TDIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with TDIST.
=TDIST2T(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with TDIST2T.
=TDISTRT(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with TDISTRT.
=TINV(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with TINV.
=TINV2T(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with TINV2T.
=TTEST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with TTEST.
=VAR(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with VAR.
=VAR.P(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with VAR.P.
=VAR.S(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with VAR.S.
=VARA(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with VARA.
=VARP(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with VARP.
=VARPA(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with VARPA.
=VARS(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with VARS.
=WEIBULL.DIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with WEIBULL.DIST.
=WEIBULLDIST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with WEIBULLDIST.
=Z.TEST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with Z.TEST.
=ZTEST(...)Calculates statistical aggregations, probability density, cumulative distribution, or hypothesis tests with ZTEST.
Money & Loans
28 Formulas=CUMIPMT(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with CUMIPMT.
=CUMPRINC(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with CUMPRINC.
=DB(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with DB.
=DDB(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with DDB.
=DOLLARDE(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with DOLLARDE.
=DOLLARFR(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with DOLLARFR.
=EFFECT(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with EFFECT.
=FV(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with FV.
=FVSCHEDULE(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with FVSCHEDULE.
=IPMT(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with IPMT.
=IRR(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with IRR.
=ISPMT(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with ISPMT.
=MIRR(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with MIRR.
=NOMINAL(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with NOMINAL.
=NPER(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with NPER.
=NPV(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with NPV.
=PDURATION(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with PDURATION.
=PMT(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with PMT.
=PPMT(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with PPMT.
=PV(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with PV.
=RATE(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with RATE.
=RRI(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with RRI.
=SLN(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with SLN.
=SYD(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with SYD.
=TBILLEQ(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with TBILLEQ.
=TBILLPRICE(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with TBILLPRICE.
=TBILLYIELD(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with TBILLYIELD.
=XNPV(...)Calculates financial investment, cash flow valuation, depreciation, or loan payments with XNPV.
Advanced & Numbers
46 Formulas=BIN2DEC(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for BIN2DEC.
=BIN2HEX(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for BIN2HEX.
=BIN2OCT(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for BIN2OCT.
=BITAND(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for BITAND.
=BITLSHIFT(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for BITLSHIFT.
=BITOR(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for BITOR.
=BITRSHIFT(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for BITRSHIFT.
=BITXOR(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for BITXOR.
=COMPLEX(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for COMPLEX.
=DEC2BIN(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for DEC2BIN.
=DEC2HEX(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for DEC2HEX.
=DEC2OCT(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for DEC2OCT.
=DELTA(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for DELTA.
=ERF(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for ERF.
=ERFC(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for ERFC.
=HEX2BIN(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for HEX2BIN.
=HEX2DEC(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for HEX2DEC.
=HEX2OCT(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for HEX2OCT.
=IMABS(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMABS.
=IMAGINARY(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMAGINARY.
=IMARGUMENT(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMARGUMENT.
=IMCONJUGATE(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMCONJUGATE.
=IMCOS(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMCOS.
=IMCOSH(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMCOSH.
=IMCOT(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMCOT.
=IMCSC(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMCSC.
=IMCSCH(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMCSCH.
=IMDIV(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMDIV.
=IMEXP(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMEXP.
=IMLN(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMLN.
=IMLOG10(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMLOG10.
=IMLOG2(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMLOG2.
=IMPOWER(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMPOWER.
=IMPRODUCT(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMPRODUCT.
=IMREAL(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMREAL.
=IMSEC(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMSEC.
=IMSECH(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMSECH.
=IMSIN(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMSIN.
=IMSINH(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMSINH.
=IMSQRT(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMSQRT.
=IMSUB(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMSUB.
=IMSUM(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMSUM.
=IMTAN(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for IMTAN.
=OCT2BIN(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for OCT2BIN.
=OCT2DEC(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for OCT2DEC.
=OCT2HEX(invalue, ...)Performs engineering, bitwise conversion, or complex number arithmetic for OCT2HEX.
Cell Checks & Info
18 Formulas=FORMULATEXT(value)Inspects cell data type, error status, content properties, or metadata with FORMULATEXT.
=ISBINARY(value)Inspects cell data type, error status, content properties, or metadata with ISBINARY.
=ISBLANK(value)Inspects cell data type, error status, content properties, or metadata with ISBLANK.
=ISERR(value)Inspects cell data type, error status, content properties, or metadata with ISERR.
=ISERROR(value)Inspects cell data type, error status, content properties, or metadata with ISERROR.
=ISEVEN(value)Inspects cell data type, error status, content properties, or metadata with ISEVEN.
=ISFORMULA(value)Inspects cell data type, error status, content properties, or metadata with ISFORMULA.
=ISLOGICAL(value)Inspects cell data type, error status, content properties, or metadata with ISLOGICAL.
=ISNA(value)Inspects cell data type, error status, content properties, or metadata with ISNA.
=ISNONTEXT(value)Inspects cell data type, error status, content properties, or metadata with ISNONTEXT.
=ISNUMBER(value)Inspects cell data type, error status, content properties, or metadata with ISNUMBER.
=ISODD(value)Inspects cell data type, error status, content properties, or metadata with ISODD.
=ISREF(value)Inspects cell data type, error status, content properties, or metadata with ISREF.
=ISTEXT(value)Inspects cell data type, error status, content properties, or metadata with ISTEXT.
=N(value)Inspects cell data type, error status, content properties, or metadata with N.
=NA(value)Inspects cell data type, error status, content properties, or metadata with NA.
=T(value)Inspects cell data type, error status, content properties, or metadata with T.
=TYPE(value)Inspects cell data type, error status, content properties, or metadata with TYPE.
Frequently Asked Questions
Everything you need to know about using this online spreadsheet practice playground.
Ready to Practice Excel Formulas?
Open our spreadsheet practice sandbox or explore ready-to-use templates in seconds.
Practice Spreadsheet Now