excel-formulas

Excel Formulas Skill

This skill enables AI agents to create, understand, and manage Excel formulas for calculations and data transformations.

When to Use

Use this skill when the user wants to:

• Add calculations to spreadsheets
• Create dynamic formulas
• Build summary reports
• Perform data transformations
• Understand existing formulas

Prerequisites

• MCP Excel Server must be running
• Understanding of Excel formula syntax
• Data must be properly structured

Formula Fundamentals

Basic Syntax

Excel formulas start with =:

=SUM(A1:A10)
=AVERAGE(B1:B100)
=IF(C1>100,"High","Low")

Cell References

Type	Example	Meaning
Relative	A1	Changes when copied
Absolute	$A$1	Never changes
Mixed	$A1	Column fixed, row changes
Mixed	A$1	Row fixed, column changes

Common Functions

Math & Statistics

=SUM(range)           # Add values
=AVERAGE(range)       # Mean
=MEDIAN(range)        # Middle value
=MIN(range)           # Minimum
=MAX(range)           # Maximum
=COUNT(range)         # Count numbers
=COUNTA(range)        # Count non-empty
=STDEV(range)         # Standard deviation

Logic

=IF(condition, true, false)        # Conditional
=AND(condition1, condition2)       # All true
=OR(condition1, condition2)        # Any true
=NOT(condition)                    # Reverse
=IFS(cond1,val1,cond2,val2,...)   # Multiple conditions

Text

=CONCATENATE(text1, text2)   # Join text
=LEFT(text, num)              # Left characters
=RIGHT(text, num)             # Right characters
=LEN(text)                    # Length
=UPPER(text)                  # Uppercase
=LOWER(text)                  # Lowercase
=TRIM(text)                   # Remove spaces

Lookup

=VLOOKUP(value, range, col, match)   # Vertical lookup
=HLOOKUP(value, range, row, match)   # Horizontal lookup
=INDEX(range, row, col)              # Return value
=MATCH(value, range, type)           # Find position