Language
한국어English

Excel or Sheets formula

CodingWork & Email

Give your column layout and a real row, and get one formula with a line on how it works.

Fill the blanks and it copies as you filled it

Give me one formula.

- Tool: 
- My data: 
- One or two real rows: 
- What I want to get: 
- One formula and one line on how it works
0 of 4 blanks filled · anything left blank copies with its brackets

What this prompt does

Compared with asking the same thing without the length and format lines.estimate

Estimated output tokens
700
Asked loosely
180
This prompt
Energy (Wh)
1.215
Asked loosely
0.423
This prompt

Tokens estimated from characters; energy measured by Jegham et al. 2025.

What that saves
15.8 Wh · 5.54 gCO₂e · 74 mL — assuming 20 uses a day — the global average is 3.7 (Chatterji et al. 2025)

Tap a card for how the conversion was done.

Reported backfire — Specifying output lengthSpecifying a length longer than needed backfires (a 34% increase in 11% of scenarios)
Where these figures come from

Published figures for the rule itself — not what this prompt saves.

Specifying output length
38.7%mean reduction · 95% CI 29.7–47.7%
Podder et al. 2026 BP#5 · 18 use cases / 57 prompts
by modelGPT-4o 35%Command R+ 49%Mistral-7B 32%
Reduced in every scenario. No backfire reported

Often used alongside

See all 202