Generate Excel Formulas from Plain English

Stuck on a complex calculation? Describe what you need to do, and our AI-powered tool writes the Excel formula for you. Get accurate VLOOKUP, IF, and SUMIF formulas instantly.

Excel Formula Generator

Browse and copy common Excel formulas

IF

Returns one value if condition is true, another if false

=IF(condition, value_if_true, value_if_false)

Example: =IF(A1>10, "Yes", "No")

IFS

Checks multiple conditions

=IFS(condition1, value1, condition2, value2, ...)

Example: =IFS(A1>90, "A", A1>80, "B", A1>70, "C")

IFERROR

Returns a custom value if formula results in error

=IFERROR(value, value_if_error)

Example: =IFERROR(A1/B1, "Error")

AND

Returns TRUE if all conditions are true

=AND(condition1, condition2, ...)

Example: =AND(A1>0, A1<100)

OR

Returns TRUE if any condition is true

=OR(condition1, condition2, ...)

Example: =OR(A1="Yes", A1="Y")

NOT

Reverses the logical value

=NOT(condition)

Example: =NOT(A1="Complete")

IF AND

IF with multiple conditions

=IF(AND(condition1, condition2), value_if_true, value_if_false)

Example: =IF(AND(A1>0, B1>0), "Both positive", "Check values")

IF OR

IF with any condition true

=IF(OR(condition1, condition2), value_if_true, value_if_false)

Example: =IF(OR(A1="Yes", A1="Y"), "Approved", "Denied")

CONCATENATE

Joins multiple text strings

=CONCATENATE(text1, text2, ...)

Example: =CONCATENATE(A1, " ", B1)

TEXTJOIN

Joins text with delimiter

=TEXTJOIN(delimiter, ignore_empty, text1, ...)

Example: =TEXTJOIN(", ", TRUE, A1:A10)

LEFT

Extracts characters from the left

=LEFT(text, num_chars)

Example: =LEFT(A1, 3)

RIGHT

Extracts characters from the right

=RIGHT(text, num_chars)

Example: =RIGHT(A1, 3)

MID

Extracts characters from the middle

=MID(text, start_num, num_chars)

Example: =MID(A1, 2, 3)

LEN

Returns the length of text

=LEN(text)

Example: =LEN(A1)

TRIM

Removes extra spaces

=TRIM(text)

Example: =TRIM(A1)

UPPER

Converts to uppercase

=UPPER(text)

Example: =UPPER(A1)

LOWER

Converts to lowercase

=LOWER(text)

Example: =LOWER(A1)

PROPER

Capitalizes first letter of each word

=PROPER(text)

Example: =PROPER(A1)

SUBSTITUTE

Replaces text in a string

=SUBSTITUTE(text, old_text, new_text)

Example: =SUBSTITUTE(A1, "old", "new")

REPLACE

Replaces characters at specific position

=REPLACE(old_text, start_num, num_chars, new_text)

Example: =REPLACE(A1, 1, 3, "XXX")

FIND

Finds position of text (case-sensitive)

=FIND(find_text, within_text)

Example: =FIND("a", A1)

SEARCH

Finds position of text (not case-sensitive)

=SEARCH(find_text, within_text)

Example: =SEARCH("a", A1)

SUM

Adds all numbers

=SUM(number1, number2, ...)

Example: =SUM(A1:A10)

SUMIF

Sums cells that meet criteria

=SUMIF(range, criteria, [sum_range])

Example: =SUMIF(A1:A10, ">50", B1:B10)

SUMIFS

Sums cells that meet multiple criteria

=SUMIFS(sum_range, criteria_range1, criteria1, ...)

Example: =SUMIFS(C1:C10, A1:A10, ">50", B1:B10, "Yes")

AVERAGE

Returns the average

=AVERAGE(number1, number2, ...)

Example: =AVERAGE(A1:A10)

AVERAGEIF

Averages cells that meet criteria

=AVERAGEIF(range, criteria, [average_range])

Example: =AVERAGEIF(A1:A10, ">50")

COUNT

Counts cells with numbers

=COUNT(value1, value2, ...)

Example: =COUNT(A1:A10)

COUNTA

Counts non-empty cells

=COUNTA(value1, value2, ...)

Example: =COUNTA(A1:A10)

COUNTIF

Counts cells that meet criteria

=COUNTIF(range, criteria)

Example: =COUNTIF(A1:A10, ">50")

COUNTIFS

Counts cells that meet multiple criteria

=COUNTIFS(criteria_range1, criteria1, ...)

Example: =COUNTIFS(A1:A10, ">50", B1:B10, "Yes")

ROUND

Rounds to specified digits

=ROUND(number, num_digits)

Example: =ROUND(A1, 2)

ROUNDUP

Rounds up

=ROUNDUP(number, num_digits)

Example: =ROUNDUP(A1, 0)

ROUNDDOWN

Rounds down

=ROUNDDOWN(number, num_digits)

Example: =ROUNDDOWN(A1, 0)

MOD

Returns remainder after division

=MOD(number, divisor)

Example: =MOD(A1, 10)

POWER

Raises number to a power

=POWER(number, power)

Example: =POWER(A1, 2)

SQRT

Returns square root

=SQRT(number)

Example: =SQRT(A1)

TODAY

Returns current date

=TODAY()

Example: =TODAY()

NOW

Returns current date and time

=NOW()

Example: =NOW()

DATE

Creates a date

=DATE(year, month, day)

Example: =DATE(2024, 1, 15)

DATEDIF

Calculates difference between dates

=DATEDIF(start_date, end_date, unit)

Example: =DATEDIF(A1, B1, "Y")

YEAR

Extracts year from date

=YEAR(date)

Example: =YEAR(A1)

MONTH

Extracts month from date

=MONTH(date)

Example: =MONTH(A1)

DAY

Extracts day from date

=DAY(date)

Example: =DAY(A1)

WEEKDAY

Returns day of week

=WEEKDAY(date, [return_type])

Example: =WEEKDAY(A1)

WORKDAY

Returns workday after specified days

=WORKDAY(start_date, days, [holidays])

Example: =WORKDAY(A1, 10)

NETWORKDAYS

Returns workdays between dates

=NETWORKDAYS(start_date, end_date, [holidays])

Example: =NETWORKDAYS(A1, B1)

EOMONTH

Returns last day of month

=EOMONTH(start_date, months)

Example: =EOMONTH(A1, 0)

VLOOKUP

Vertical lookup

=VLOOKUP(lookup_value, table_array, col_index, [range_lookup])

Example: =VLOOKUP(A1, Sheet2!A:B, 2, FALSE)

HLOOKUP

Horizontal lookup

=HLOOKUP(lookup_value, table_array, row_index, [range_lookup])

Example: =HLOOKUP(A1, Sheet2!1:2, 2, FALSE)

XLOOKUP

Modern lookup function

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])

Example: =XLOOKUP(A1, B1:B10, C1:C10, "Not found")

INDEX

Returns value at position

=INDEX(array, row_num, [col_num])

Example: =INDEX(A1:C10, 5, 2)

MATCH

Returns position of value

=MATCH(lookup_value, lookup_array, [match_type])

Example: =MATCH(A1, B1:B10, 0)

INDEX MATCH

Flexible lookup combination

=INDEX(return_range, MATCH(lookup_value, lookup_range, 0))

Example: =INDEX(C1:C10, MATCH(A1, B1:B10, 0))

MIN

Returns minimum value

=MIN(number1, number2, ...)

Example: =MIN(A1:A10)

MAX

Returns maximum value

=MAX(number1, number2, ...)

Example: =MAX(A1:A10)

MEDIAN

Returns median value

=MEDIAN(number1, number2, ...)

Example: =MEDIAN(A1:A10)

MODE

Returns most frequent value

=MODE(number1, number2, ...)

Example: =MODE(A1:A10)

STDEV

Returns standard deviation

=STDEV(number1, number2, ...)

Example: =STDEV(A1:A10)

VAR

Returns variance

=VAR(number1, number2, ...)

Example: =VAR(A1:A10)

LARGE

Returns k-th largest value

=LARGE(array, k)

Example: =LARGE(A1:A10, 2)

SMALL

Returns k-th smallest value

=SMALL(array, k)

Example: =SMALL(A1:A10, 2)

RANK

Returns rank of number

=RANK(number, ref, [order])

Example: =RANK(A1, A1:A10, 0)

How the Excel Formula Generator Works

Browse formulas by category: Logical, Text, Math & Stats, Date & Time, Lookup, and Statistical. Each category contains commonly used Excel formulas with explanations.

Click any formula to see its syntax, description, and a practical example. Copy the formula with one click. Use as a reference while building your spreadsheets.

Filter formulas by category to find what you need quickly. From simple SUM to complex INDEX/MATCH combinations. Your Excel formula cheat sheet, always available. All content loads instantly.

When You'd Actually Use This

Learning Excel formulas

New to Excel? Browse formulas by category. Understand what each does before using. Build your formula vocabulary systematically.

Finding the right formula

Know what you want to do, not which formula to use. Browse categories to discover options. Find VLOOKUP when you need to search.

Remembering syntax

Know the formula, forget the argument order. Quick reference for SUMIF range vs criteria. No need to search documentation.

Discovering new functions

Find formulas you didn't know existed. TEXTJOIN for concatenation. IFS for multiple conditions. Expand your Excel toolkit.

Training others

Teach Excel formulas to team members. Use this as a reference guide. Consistent formula usage across the organization.

Quick lookup during work

Building a complex spreadsheet. Need a formula fast. Quick search and copy. Keep your workflow uninterrupted.

What to Know Before Using

Formulas are categorized by function.Logical for IF statements. Text for string manipulation. Math for calculations. Lookup for finding data. Choose the right category.

Examples show typical usage.Cell references like A1, B2 are examples. Replace with your actual cell references. Adapt the pattern to your data.

Some formulas need newer Excel.XLOOKUP, IFS, TEXTJOIN require Excel 2019 or 365. Older versions need alternatives. Check your Excel version.

Formula syntax is standardized.Equals sign starts the formula. Function name, parentheses, arguments separated by commas. Consistent across all formulas.

Pro tip: For complex formulas, build them step by step. Test each part in a separate cell. Combine once each piece works correctly.

Common Questions

What's the difference between VLOOKUP and XLOOKUP?

XLOOKUP is newer and more flexible. Can look left, has built-in error handling. VLOOKUP is older but widely compatible. Use XLOOKUP if available.

When should I use INDEX/MATCH instead of VLOOKUP?

INDEX/MATCH is more flexible. Can look left, handles inserted columns better. Slightly more complex but more robust. Preferred by power users.

What does the dollar sign mean in formulas?

Dollar signs create absolute references. $A$1 stays fixed when copying. A1 changes relatively. Mix like $A1 for column-fixed, row-relative.

How do I combine multiple conditions?

Use AND() or OR() inside IF. Or use IFS for multiple conditions. SUMIFS and COUNTIFS handle multiple criteria directly.

Can I use formulas across sheets?

Yes, use SheetName!CellReference. Like =SUM(Sheet2!A1:A10). Works across workbooks too with proper file path references.

What are array formulas?

Formulas that operate on ranges. In newer Excel, dynamic arrays spill automatically. Older Excel needs Ctrl+Shift+Enter. Powerful for complex calculations.

Are these formulas compatible with Google Sheets?

Most formulas work in both. Some Excel-specific functions don't exist in Sheets. Google has some unique functions too. Check compatibility for your needs.

Other Free Tools

Search tools