{"product_id":"ai-excel-formula-generator","title":"AI Excel Formula Generator","description":"\u003cdiv style=\"font-family: 'DM Sans', sans-serif; color: #1A1A18;\"\u003e\n\n  \u003cdiv style=\"background: #E8EDFB; border: 1px solid #C7D2F0; border-radius: 8px; padding: 16px 20px; margin-bottom: 20px;\"\u003e\n    \u003cp style=\"margin: 0; font-size: 12px; font-weight: 600; color: #2C4BA0; letter-spacing: 0.06em; text-transform: uppercase;\"\u003eTech \u0026amp; Development Prompts\u003c\/p\u003e\n    \u003cp style=\"margin: 6px 0 0; font-size: 13px; color: #555550; line-height: 1.5;\"\u003eDescribe what you need your spreadsheet to do — get the exact formula, why it works, and what breaks it.\u003c\/p\u003e\n  \u003c\/div\u003e\n\n  \u003cp style=\"font-size: 14px; color: #555550; line-height: 1.7; margin: 0 0 20px;\"\u003e\n    Paste this prompt into Claude, ChatGPT, or any AI chat, describe what you want your data to do in plain English, and get back the exact, ready-to-paste formula for your version of Excel or Google Sheets — plus a plain-English breakdown of how it works and the specific ways that formula type tends to fail.\n  \u003c\/p\u003e\n\n  \u003cp style=\"font-size: 14px; color: #555550; line-height: 1.7; margin: 0 0 20px;\"\u003e\n    This isn't a \"here's a VLOOKUP, good luck\" answer. It flags version compatibility between 365 dynamic arrays, legacy CSE array formulas, and Google Sheets syntax, hands you a backup formula approach with honest trade-offs, and gives you a testing checklist before you trust the output on a live sheet. Works with Claude, ChatGPT, or any AI chat model.\n  \u003c\/p\u003e\n\n  \u003ch3 style=\"font-size: 13px; font-weight: 600; color: #1A1A18; margin: 0 0 10px; text-transform: uppercase; letter-spacing: 0.04em;\"\u003eWhat you get\u003c\/h3\u003e\n  \u003cul style=\"font-size: 13px; color: #555550; line-height: 1.9; padding-left: 18px; margin: 0 0 24px;\"\u003e\n    \u003cli\u003eOne production-ready prompt (600+ words)\u003c\/li\u003e\n    \u003cli\u003eThe exact, ready-to-paste formula with every cell\/range reference clearly marked\u003c\/li\u003e\n    \u003cli\u003eA plain-English, step-by-step explanation of how the formula works\u003c\/li\u003e\n    \u003cli\u003eCommon pitfalls and errors flagged before they happen (#N\/A, #REF!, #SPILL!)\u003c\/li\u003e\n    \u003cli\u003eAn alternative formula approach plus a live-sheet testing checklist\u003c\/li\u003e\n  \u003c\/ul\u003e\n\n  \u003ch3 style=\"font-size: 13px; font-weight: 600; color: #1A1A18; margin: 0 0 10px; text-transform: uppercase; letter-spacing: 0.04em;\"\u003eSub-types covered\u003c\/h3\u003e\n  \u003cdiv style=\"display: flex; flex-wrap: wrap; gap: 8px; margin-bottom: 24px;\"\u003e\n    \u003cspan style=\"background: #E8EDFB; color: #2C4BA0; border-radius: 20px; padding: 4px 12px; font-size: 11px; font-weight: 500;\"\u003eVLOOKUP \u0026amp; XLOOKUP\u003c\/span\u003e\n    \u003cspan style=\"background: #E8EDFB; color: #2C4BA0; border-radius: 20px; padding: 4px 12px; font-size: 11px; font-weight: 500;\"\u003eINDEX\/MATCH\u003c\/span\u003e\n    \u003cspan style=\"background: #E8EDFB; color: #2C4BA0; border-radius: 20px; padding: 4px 12px; font-size: 11px; font-weight: 500;\"\u003eDynamic Arrays\u003c\/span\u003e\n    \u003cspan style=\"background: #E8EDFB; color: #2C4BA0; border-radius: 20px; padding: 4px 12px; font-size: 11px; font-weight: 500;\"\u003eNested IF Logic\u003c\/span\u003e\n    \u003cspan style=\"background: #E8EDFB; color: #2C4BA0; border-radius: 20px; padding: 4px 12px; font-size: 11px; font-weight: 500;\"\u003eGoogle Sheets Syntax\u003c\/span\u003e\n    \u003cspan style=\"background: #E8EDFB; color: #2C4BA0; border-radius: 20px; padding: 4px 12px; font-size: 11px; font-weight: 500;\"\u003eExcel 365 \u0026amp; Legacy\u003c\/span\u003e\n    \u003cspan style=\"background: #E8EDFB; color: #2C4BA0; border-radius: 20px; padding: 4px 12px; font-size: 11px; font-weight: 500;\"\u003eFinancial Formulas\u003c\/span\u003e\n  \u003c\/div\u003e\n\n  \u003cdiv style=\"border-top: 1px solid #E8E6E0; padding-top: 16px;\"\u003e\n    \u003cp style=\"font-size: 11px; color: #BBBBAA; margin: 0; font-family: 'DM Mono', monospace;\"\u003eai-excel-formula-generator-prompt.txt  ·  Works with Claude, ChatGPT \u0026amp; more  ·  Instant use\u003c\/p\u003e\n  \u003c\/div\u003e\n\n\u003c\/div\u003e","brand":"Kissmyskills","offers":[{"title":"Default","offer_id":58282043506952,"sku":"ai-excel-formula-generator","price":12.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1036\/1444\/7880\/files\/ai-excel-formula-generator-cover.png?v=1784730579","url":"https:\/\/kissmyskills.com\/de\/products\/ai-excel-formula-generator","provider":"KissMySkills","version":"1.0","type":"link"}