TechnicalCollectible prompt
Excel and Google Sheets formula builder
Act as a spreadsheet expert. Build a formula in {{spreadsheet_app}} that does this: {{calculation_goal}}
How my sheet is laid out: {{sheet_layout}}
My language and region settings: {{language_and_region}}
Use the argument separator and decimal mark that match my region, and localized function names if my spreadsheet isn't in English. Prefer modern functions such as XLOOKUP, FILTER, or LET when my version supports them, and give a fallback for older versions.
Return:
1. The formula, ready to paste
2. Which cell it goes in, and whether to fill it down or across
3. A plain-English breakdown of each part
4. A small example with inputs and the expected output
5. Error values it might show, and how to handle them
If the layout is ambiguous, ask before assuming which ranges to use.
Technicalnvoka.com/library/nvoka-excel-google-sheets-formulaScan to open
Technical
Excel and Google Sheets formula builder
Get a working spreadsheet formula, explained step by step, that fits your regional settings.
Curated by Nvoka
Microsoft CopilotGeminiChatGPTClaude
Make it yours
Fill in the blanks and change any word. Only your copy changes, never the card.
Fill in the blanks
0 of 4 filledYour prompt
Act as a spreadsheet expert. Build a formula in {{spreadsheet_app}} that does this: {{calculation_goal}}
How my sheet is laid out: {{sheet_layout}}
My language and region settings: {{language_and_region}}
Use the argument separator and decimal mark that match my region, and localized function names if my spreadsheet isn't in English. Prefer modern functions such as XLOOKUP, FILTER, or LET when my version supports them, and give a fallback for older versions.
Return:
1. The formula, ready to paste
2. Which cell it goes in, and whether to fill it down or across
3. A plain-English breakdown of each part
4. A small example with inputs and the expected output
5. Error values it might show, and how to handle them
If the layout is ambiguous, ask before assuming which ranges to use.
