Excel formulas, made simple.
Create a formula in Excel, find the excel formula for percentage, subtract values, translate English to Hindi, and lock cells — all with a free formula generator, a searchable excel formula list, and live sandboxes that recalculate as you type.
Everything you need to master Excel formula syntax.
Excel Formula Generator.
Describe your goal in plain English and the generator builds the correct syntax with a parameter breakdown, example data table, and copy-ready output.
Build a formulaExcel Formula List.
Browse every major formula across Lookup, Logical, Text, Math, Date, Financial, and Dynamic Array categories, with search and instant filtering.
Browse formulasLive Formula Sandbox.
Every formula runs inside an interactive spreadsheet. Change any input cell and watch the result recalculate instantly, so you learn by doing.
Open a sandboxWhat is ExcelFormulas?
ExcelFormulas is a free, browser-based Excel formula tool that helps you create a formula in Excel, understand exactly how it works, and test it live in an interactive spreadsheet sandbox. Whether you need the excel formula for percentage, an excel formula for subtraction, or a reliable way to lock a cell in an Excel formula, this site turns Excel's steep learning curve into something you can master in a few minutes. There are no downloads, no sign-ups, and no installations — open your browser and start building.
An excel formula list you can actually play with.
The core of the site is a searchable excel formula list. Every formula is presented with its exact syntax, a plain-English explanation of how it works, best-practice tips, and common gotchas. But unlike a static reference page, every formula also ships with an interactive spreadsheet grid. Click a cell, type a new value, and watch the result recalculate in real time. This hands-on sandbox is the fastest way to learn, because you see cause and effect immediately — change a score from 74 to 90 and the IF formula instantly flips the grade from Pass to Fail.
How to create a formula in Excel.
Every formula here follows the same rule you use inside Microsoft Excel: it starts with an equal sign (=). To create a formula in Excel, select a cell, type =, and choose the function you need, such as SUM, AVERAGE, XLOOKUP, or SUMIFS. The interactive builder on each formula page lets you fill in the arguments visually, then copies the finished formula to your clipboard so you can paste it straight into your spreadsheet. There is no faster way to learn Excel formula syntax than building it argument by argument and watching the output update.
The excel formula for percentage and subtraction.
Two of the most-searched Excel tasks are covered head-on. The excel formula for percentage is a simple division formatted as a percentage — for example, =B2/C2 to find what share of a total one value represents, or =(B2-A2)/A2 to calculate percentage change over time. The excel formula for subtraction is even simpler: Excel has no SUBTRACT function, so you use the minus sign directly. =A2-B2 subtracts the value in B2 from the value in A2. Both patterns appear throughout the cheat sheet with worked examples you can test live in the sandbox before you trust them with real data.
How to lock a cell in an Excel formula.
Copying a formula down a column is powerful, but relative references shift with every row. That is why knowing how to lock a cell in an Excel formula is so important. Add dollar signs to freeze the reference: $A$2 locks both the column and the row, A$2 locks the row only, and $A2 locks the column only. This matters when you build a formula once and drag it across hundreds of rows — for example, a tax rate or discount stored in one fixed cell should never move while the rest of the formula updates. The lock-a-cell pattern appears across the tutorials and in the tips for SUMIFS and VLOOKUP.
Translate English to Hindi in an Excel formula.
Working with mixed-language data? You can translate English to Hindi in Excel using the GOOGLETRANSLATE formula in Google Sheets — =GOOGLETRANSLATE(A2, "en", "hi") — or Microsoft Translator inside Excel for Microsoft 365. The tools here focus on formula construction, so you can combine a translation function with text formulas such as TEXTJOIN or CONCAT to build bilingual reports from a single source cell. Once the translation formula is in place, the same locking and percentage patterns you learned above keep everything consistent across your workbook.
An excel formula list and an excel formula generator.
The excel formula list is organized into practical categories — Lookup & Reference, Logical, Text, Math & Statistical, Date & Time, Financial, and Dynamic Arrays — with a search box that filters results instantly as you type. When you are not sure which function fits your problem, describe your goal in plain English to the excel formula generator, and it constructs the correct syntax for you, complete with a parameter breakdown, an example data table, and step-by-step instructions for pasting it into Excel or Google Sheets.
ExcelFormulas exists for one reason: to make Excel formulas less intimidating. From your very first =SUM to advanced XLOOKUP pipelines, everything you need to create a formula in Excel, understand what it does, and lock it into place is here — free and interactive. Open the excel formula list, step inside a sandbox, and start building something today.
Excel formula questions, answered.
How do I create a formula in Excel?
Select a cell, type an equal sign (=), then enter the function name followed by its arguments in parentheses. For example, =SUM(A2:A10) adds the numbers in that range. Every formula page on this site includes an interactive builder that constructs the syntax for you.
What is the excel formula for percentage?
There is no dedicated percentage function. The excel formula for percentage is a division: =B2/C2 finds the share of a total, and =(B2-A2)/A2 calculates percentage change. Format the result cell as a percentage to display it as a value such as 25%.
How do I lock a cell in an Excel formula?
Add dollar signs to the cell reference to lock it. $A$2 locks both the column and row, A$2 locks the row only, and $A2 locks the column only. Locking is essential when you copy a formula down a column and want one reference to stay fixed.
How do I subtract in Excel?
Excel has no SUBTRACT function. The excel formula for subtraction uses the minus sign directly, for example =A2-B2 subtracts the value in B2 from the value in A2.
How do I use VLOOKUP in Excel?
The excel formula for VLOOKUP is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). It searches the first column of a table for a value and returns a matching value from the column you specify. For example, =VLOOKUP(D2, A2:B6, 2, FALSE) looks up the ID in D2 against column A and returns the matching name from column B.
How do I sum cells with multiple conditions in Excel?
Use the SUMIFS excel formula, which adds values that match one or more conditions: =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2]). For example, =SUMIFS(D2:D10, A2:A10, "East", B2:B10, ">100") sums only the rows in the East region with a value over 100.
What is the excel formula for an IF statement?
The excel formula for an IF statement is =IF(logical_test, value_if_true, value_if_false). For example, =IF(B2>=50, "Pass", "Fail") returns "Pass" when B2 is 50 or higher and "Fail" otherwise. Chain multiple conditions with the IFS formula: =IFS(B2>=90, "A", B2>=80, "B", TRUE, "C").
How do I count cells that match a condition in Excel?
Use the COUNTIF excel formula to count cells that meet a single condition, or COUNTIFS for multiple conditions. For example, =COUNTIF(A2:A10, "Apple") counts how many cells in the range equal "Apple", and =COUNTIFS(A2:A10, "Apple", B2:B10, ">10") adds a second condition.
How do I combine text from multiple cells in Excel?
Join text with the CONCAT or TEXTJOIN excel formula. =CONCAT(A2, B2) merges the contents of A2 and B2 with no separator, while =TEXTJOIN("-", TRUE, A2, B2, C2) joins them with a "-" separator and skips empty cells. You can also use the & operator, such as =A2 & " " & B2.
What is the excel formula for the average?
The excel formula for the average is =AVERAGE(range), which returns the arithmetic mean. For example, =AVERAGE(A2:A10) averages the numbers in that range. Use AVERAGEIF or AVERAGEIFS to average only the cells that meet specific conditions.
How do I round a number in Excel?
Use the ROUND excel formula to round a number to a set number of digits: =ROUND(number, num_digits). For example, =ROUND(A2, 2) rounds to two decimal places, =ROUND(A2, 0) rounds to the nearest whole number, and =ROUND(A2, -1) rounds to the nearest ten.
How do I remove extra spaces from text in Excel?
The excel formula for cleaning up text is =TRIM(A2), which removes leading, trailing, and repeated spaces from a cell. Combine it with PROPER, UPPER, or LOWER to fix capitalization too, such as =PROPER(TRIM(A2)) to convert text to proper case.
How do I find the difference between two dates in Excel?
To find the number of days between two dates, subtract the earlier date from the later one, for example =B2-A2. For a result in a specific unit such as months or years, use =DATEDIF(A2, B2, "m") or =DATEDIF(A2, B2, "y"). The NETWORKDAYS excel formula counts only working days between two dates.
Is the excel formula generator free to use?
Yes. The excel formula generator, the full excel formula list, and every interactive sandbox are completely free, with no sign-up or download required.
Start building your first Excel formula.
No sign-up, no cost, no install. Open the excel formula list, generate a formula from plain English, or step inside a live sandbox and start experimenting today.