Master Excel formulas.
Learn logical operations, matrix searches, text formatting, and dynamic arrays in the browser. Type inputs and see results update instantly.
Learn how to use Excel formulas in a fun and easy way! Change values inside our grids and see how math, text, and searches work instantly.
Stop guessing cell coordinates.
Static screenshots don't show how formulas breathe. Below is a live spreadsheet simulation rendering XLOOKUP.
Click inside cell D2 (currently 103).
Type in 101, 104, or 105 and press Enter.
The result in cell E2 will immediately update using our interactive calculations.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Emp ID | Department | Salary | Search ID | Result Dept |
| 2 | |||||
| 3 | |||||
| 4 | |||||
| 5 | |||||
| 6 |
Translate English to Excel.
Describe what you want to calculate, and our automated model will construct the exact formula syntax and explain how it operates.
Browse Formulas.
Select a category or type a formula name to filter our high-fidelity sandboxes.
XLOOKUP.
Searches a range or array and returns the corresponding item from a second range or array.
VLOOKUP.
Searches for a value in the first column of a table and returns a value in the same row from a specified column.
INDEX & MATCH.
Combines two formulas to perform powerful two-way lookups, searching left and right.
IF.
Checks whether a condition is met, and returns one value if TRUE, and another if FALSE.
IFS.
Checks multiple conditions and returns a value corresponding to the first TRUE condition.
IFERROR.
Returns a specified value if a formula evaluates to an error; otherwise, returns the result of the formula.
SUMIFS.
Sums cells that meet multiple criteria.
COUNTIFS.
Counts cells that meet multiple criteria.
TEXTJOIN.
Combines text from multiple ranges or strings, and includes a delimiter you specify between each text value.
FILTER.
Filters a range or array based on conditions you define, spilling matching rows automatically.
UNIQUE.
Extracts all unique values from a range or array, removing duplicates automatically.
TODAY.
Returns the current date.
NETWORKDAYS.
Returns the number of whole working days between two dates, excluding weekends and optional holidays.
PMT.
Calculates the payment for a loan based on constant payments and a constant interest rate.
SUM.
Adds all numbers in a range of cells.
AVERAGE.
Returns the average (arithmetic mean) of the arguments.
COUNT.
Counts the number of cells that contain numbers.
LEFT.
Returns the first character or characters in a text string, based on the number of characters you specify.
RIGHT.
Returns the last character or characters in a text string, based on the number of characters you specify.
TRIM.
Removes all spaces from text except for single spaces between words.
PROPER.
Capitalizes the first letter in each word of a text value.
ROUND.
Rounds a number to a specified number of digits.
AND.
Returns TRUE if all of its arguments are TRUE; returns FALSE if one or more arguments are FALSE.
OR.
Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.
CONCAT.
Combines the text from multiple ranges and/or strings.
LEN.
Returns the number of characters in a text string.
HLOOKUP.
Looks for a value in the top row of a table or array of values and returns a value in the same column from a row you specify.
No formulas found.
Try adjusting your keyword filter or switching category tabs.
Excel Basics 101.
New to spreadsheets? Here is a simple guide to understanding Excel terms.
What is a Cell?
A single box in a spreadsheet. It has an address made of its Column letter and Row number, like A1 or B5.
💡 Address: Column A, Row 1What is a Range?
A group of cells selected together. We write it with a colon (:) between the first and last cell, like A2:A6.
What is a Formula?
A math sentence that does calculations. It must always start with an equal sign (=) to tell Excel to run it.
💡 Example: =SUM(B2:B6)What is an Argument?
The inputs (ingredients) we feed into a formula. They go inside parentheses ( ) and are separated by commas.