How do I use these formulas in Excel?

Click the "Copy" button next to any formula to copy it to your clipboard. Then paste it into your Excel cell. Replace the example cell references (like A1, B1) with your actual cell references.

What formula categories are available?

The tool includes Math & Trig, Statistical, Logical, Text, Date & Time, Lookup & Reference, and Financial formulas. Use the category dropdown to filter, or search by formula name or description.

Can I modify the formulas?

Yes! The syntax shown is a template. After copying, replace the generic parameters with your specific cell references, values, or conditions. The examples show you how to structure the formula correctly.

What does the syntax mean?

The syntax shows the formula structure. Required parameters are shown without brackets, while optional parameters are in [brackets]. For example, =SUM(number1, [number2]) means number1 is required but number2 is optional.

Excel Formula Generator

Browse common Excel formulas with syntax, descriptions, and examples. Copy and use in your spreadsheets.

SUM

Syntax:=SUM(number1, [number2], ...)

Adds all numbers in a range

Example:=SUM(A1:A10)

AVERAGE

Syntax:=AVERAGE(number1, [number2], ...)

Calculates the average of numbers

Example:=AVERAGE(A1:A10)

ROUND

Syntax:=ROUND(number, num_digits)

Rounds a number to specified digits

Example:=ROUND(A1, 2)

ABS

Syntax:=ABS(number)

Returns absolute value of a number

Example:=ABS(-5)

POWER

Syntax:=POWER(number, power)

Returns the result of a number raised to a power

Example:=POWER(2, 3)

SQRT

Syntax:=SQRT(number)

Returns the square root of a number

Example:=SQRT(16)

MOD

Syntax:=MOD(number, divisor)

Returns the remainder after division

Example:=MOD(10, 3)

COUNT

Syntax:=COUNT(value1, [value2], ...)

Counts cells that contain numbers

Example:=COUNT(A1:A10)

COUNTA

Syntax:=COUNTA(value1, [value2], ...)

Counts non-empty cells

Example:=COUNTA(A1:A10)

COUNTIF

Syntax:=COUNTIF(range, criteria)

Counts cells that meet a criteria

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

MAX

Syntax:=MAX(number1, [number2], ...)

Returns the largest value

Example:=MAX(A1:A10)

MIN

Syntax:=MIN(number1, [number2], ...)

Returns the smallest value

Example:=MIN(A1:A10)

MEDIAN

Syntax:=MEDIAN(number1, [number2], ...)

Returns the median value

Example:=MEDIAN(A1:A10)

IF

Syntax:=IF(logical_test, value_if_true, value_if_false)

Returns one value if true, another if false

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

AND

Syntax:=AND(logical1, [logical2], ...)

Returns TRUE if all arguments are TRUE

Example:=AND(A1>5, B1<10)

OR

Syntax:=OR(logical1, [logical2], ...)

Returns TRUE if any argument is TRUE

Example:=OR(A1>5, B1<10)

NOT

Syntax:=NOT(logical)

Reverses the logic of its argument

Example:=NOT(A1>5)

IFERROR

Syntax:=IFERROR(value, value_if_error)

Returns a value if error, otherwise returns value

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

CONCATENATE

Syntax:=CONCATENATE(text1, [text2], ...)

Joins several text strings

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

LEFT

Syntax:=LEFT(text, [num_chars])

Returns leftmost characters

Example:=LEFT(A1, 3)

RIGHT

Syntax:=RIGHT(text, [num_chars])

Returns rightmost characters

Example:=RIGHT(A1, 3)

MID

Syntax:=MID(text, start_num, num_chars)

Returns characters from the middle

Example:=MID(A1, 2, 3)

UPPER

Syntax:=UPPER(text)

Converts text to uppercase

Example:=UPPER(A1)

LOWER

Syntax:=LOWER(text)

Converts text to lowercase

Example:=LOWER(A1)

TRIM

Syntax:=TRIM(text)

Removes extra spaces from text

Example:=TRIM(A1)

LEN

Syntax:=LEN(text)

Returns the length of text

Example:=LEN(A1)

TODAY

Syntax:=TODAY()

Returns current date

Example:=TODAY()

NOW

Syntax:=NOW()

Returns current date and time

Example:=NOW()

DATE

Syntax:=DATE(year, month, day)

Creates a date from year, month, day

Example:=DATE(2024, 1, 15)

YEAR

Syntax:=YEAR(serial_number)

Returns the year of a date

Example:=YEAR(A1)

MONTH

Syntax:=MONTH(serial_number)

Returns the month of a date

Example:=MONTH(A1)

DAY

Syntax:=DAY(serial_number)

Returns the day of a date

Example:=DAY(A1)

DATEDIF

Syntax:=DATEDIF(start_date, end_date, unit)

Calculates difference between dates

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

VLOOKUP

Syntax:=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Searches in first column and returns value

Example:=VLOOKUP(A1, B1:D10, 2, FALSE)

HLOOKUP

Syntax:=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Searches in first row and returns value

Example:=HLOOKUP(A1, B1:F5, 3, FALSE)

INDEX

Syntax:=INDEX(array, row_num, [column_num])

Returns value at intersection of row and column

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

MATCH

Syntax:=MATCH(lookup_value, lookup_array, [match_type])

Returns relative position of item

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

OFFSET

Syntax:=OFFSET(reference, rows, cols, [height], [width])

Returns a reference offset from starting cell

Example:=OFFSET(A1, 2, 3)

PMT

Syntax:=PMT(rate, nper, pv, [fv], [type])

Calculates loan payment

Example:=PMT(0.05/12, 60, 10000)

FV

Syntax:=FV(rate, nper, pmt, [pv], [type])

Calculates future value of investment

Example:=FV(0.06/12, 10*12, -100, -1000)

PV

Syntax:=PV(rate, nper, pmt, [fv], [type])

Calculates present value of investment

Example:=PV(0.08/12, 10*12, -100)

NPV

Syntax:=NPV(rate, value1, [value2], ...)

Calculates net present value

Example:=NPV(0.1, A1:A5)

IRR

Syntax:=IRR(values, [guess])

Calculates internal rate of return

Example:=IRR(A1:A5)

How to Use

Browse formulas by category or search for specific functions. Each formula card shows the syntax (how to structure it), a description of what it does, and a practical example. Click "Copy" to copy the formula syntax to your clipboard.

After copying, paste the formula into your Excel cell and replace the generic references (A1, B1, etc.) with your actual cell references. The examples show you how to use the formula with real data.