# Spreadsheet formula — prompt for Gemma

Get a formula for specific cells, a locale and empty-value handling rules.

Canonical URL: https://boswidget.ru/en/spreadsheet-formula-prompt-for-gemma/

Model: Gemma

Category: Code

Tags: formula, table, cells

![Spreadsheet formula](https://boswidget.ru/assets/images/text-preview-gm-formula-tablicy-po-usloviyam-1200.3eb4b232a4c3.webp)

Spreadsheet formula

## Prompt

I need a formula for {application}. Columns and sample rows: {data}. Calculation rule: {task}. Give the formula for the first row and explain how to fill it down. Account for specified argument separators, empty cells, zeros and errors. Explain absolute and relative references. Do not treat missing data as zero without a rule. Show expected values for three small examples. Do not claim to have opened the file or tested it in the application.

## Template fields

- `{application}` — Application. Example input: Excel or Google Sheets, locale and known version
- `{data}` — Cells. Example input: Column names, cell addresses and a few simple rows
- `{task}` — Calculation. Example input: Output requirements and rules for missing values

## Launch

[Open Gemma in YesAI](https://yesai.su/en/gemma)