Excel Formula Calculator

Test Excel formulas and see results instantly. Perfect for learning and verification.

Calculator

Function Reference (23 functions)

Math Functions

SUM

Selected

Add numbers together

SUM(10,20,30)

AVERAGE

Calculate the average of numbers

AVERAGE(10,20,30)

MAX

Find the largest number

MAX(10,20,30)

MIN

Find the smallest number

MIN(10,20,30)

COUNT

Count numbers in a list

COUNT(10,20,30)

PRODUCT

Multiply numbers together

PRODUCT(2,3,4)

ABS

Return the absolute value of a number

ABS(-5)

SIGN

Return the sign of a number (-1, 0, or 1)

SIGN(-5)

Rounding Functions

ROUND

Round a number to specified decimal places

ROUND(3.14159,2)

ROUNDUP

Round a number up

ROUNDUP(3.14159,2)

ROUNDDOWN

Round a number down

ROUNDDOWN(3.14159,2)

INT

Return the integer part of a number

INT(3.7)

Statistical Functions

MEDIAN

Find the middle value in a sorted list

MEDIAN(1,2,3,4,5)

MODE

Find the most frequently occurring value

MODE(1,2,2,3,4)

VAR

Calculate the variance of a sample

VAR(1,2,3,4,5)

STDEV

Calculate the standard deviation of a sample

STDEV(1,2,3,4,5)

Trigonometric Functions

SIN

Calculate the sine of an angle (in radians)

SIN(1.57)

COS

Calculate the cosine of an angle (in radians)

COS(0)

TAN

Calculate the tangent of an angle (in radians)

TAN(0.785)

Power Functions

POWER

Raise a number to a power

POWER(2,3)

SQRT

Calculate the square root of a number

SQRT(16)

LOG

Calculate the natural logarithm

LOG(10)

LOG10

Calculate the base-10 logarithm

LOG10(100)

How to Use

1. Select Function

Choose the Excel function you want to test from the dropdown menu.

2. Enter Values

Type numbers separated by commas, or click "Example" for sample data.

3. Calculate

Click Calculate or press Enter to see the result instantly.

Learn More About Excel Functions

Understanding Excel FormulasVLOOKUP GuidePivot Tables