Excel and Google Sheets AI Formula Generator

Description

## Spreadsheet Formula Generator

Generate formulas for [TASK]:

**Platform:** [PLATFORM — Excel/Google Sheets]
**Task:** [TASK — describe what you want to calculate]
**Data Layout:** [LAYOUT — describe your columns and rows]
**Skill Level:** [LEVEL — basic/intermediate/advanced]

**Formula Categories:**

### Lookup & Reference
```
=XLOOKUP([LOOKUP_VALUE], [LOOKUP_ARRAY], [RETURN_ARRAY], "Not Found", 0)
=INDEX([ARRAY], MATCH([VALUE], [RANGE], 0))
=FILTER([RANGE], [CRITERIA_RANGE]=[CRITERIA])
```

### Conditional Calculations
```
=SUMIFS([SUM_RANGE], [CRITERIA_RANGE1], [CRITERIA1], [CRITERIA_RANGE2], [CRITERIA2])
=COUNTIFS([RANGE1], [CRITERIA1], [RANGE2], [CRITERIA2])
=AVERAGEIFS([AVG_RANGE], [CRITERIA_RANGE], [CRITERIA])
=IFS([CONDITION1], [VALUE1], [CONDITION2], [VALUE2], TRUE, [DEFAULT])
```

### Text Manipulation
```
=TEXTJOIN(", ", TRUE, [RANGE])
=LEFT([CELL], FIND(" ", [CELL])-1)  -- First name
=PROPER(TRIM(CLEAN([CELL])))  -- Clean and capitalize
=SUBSTITUTE([CELL], [OLD], [NEW])
```

### Date & Time
```
=NETWORKDAYS([START], [END], [HOLIDAYS])
=EOMONTH([DATE], 0)  -- End of month
=DATEDIF([START], [END], "M")  -- Months between dates
=TEXT([DATE], "MMMM YYYY")  -- Format date
```

### Dynamic Arrays (Excel 365 / Google Sheets)
```
=UNIQUE(SORT(FILTER([RANGE], [CRITERIA])))
=SORTBY([DATA], [SORT_COL], 1)
=SEQUENCE(12, 1, 1, 1)  -- Generate 1-12
=LET(data, [RANGE], filtered, FILTER(data, ...), SORT(filtered))
```

**For Your Specific Task:**
1. Explain the formula step by step
2. Handle edge cases (empty cells, errors, zero division)
3. Wrap in IFERROR for production use
4. Provide both Excel and Google Sheets versions if syntax differs

**Variables:** Replace [TASK], [PLATFORM], [LAYOUT].

Free to copy and use. Compatible with Claude 4 Opus, GPT-5, Llama 4.

Usage Instructions

Tags

Compatible AI Models

Version History

Related Prompts