ChatGPT Prompt To Fix Nested Excel Formulas

Inspect the attached workbook or formula screenshot and diagnose the nested formula that is producing an error or inconsistent result. Use the actual sheet names, cell references, function names and separators visible in the material. Explain the intended calculation supported by the surrounding headers and data, marking any uncertainty. Identify the smallest correction that preserves the original business logic. Return the corrected formula in a copyable code block, explain the failure in plain language and trace the corrected result through available example rows. Check empty cells, zero values, text-formatted numbers and error propagation where relevant. Offer a more readable alternative only if the supported spreadsheet version permits it. Never invent unseen references or data. If the formula is unreadable or its intended result cannot be established, state precisely what cannot be verified.