Write Me a Google Sheets Formula
Describe what you want the cell to do. Get the exact formula, explained.
Inherited a formula you don't understand or that's throwing an error? Decode it.
I have a spreadsheet formula I either don't understand or that's broken. Here it is: [PASTE FORMULA] What I think it's supposed to do: [DESCRIBE] Error or wrong result (if any): [PASTE] Do this: 1) Explain in plain English what the formula actually does, piece by piece. 2) If it's broken, tell me exactly why and give me the corrected version. 3) If it works but is fragile or overcomplicated, suggest a cleaner version. Tell me which spreadsheet tool the fix assumes (Sheets vs Excel) if it matters. Keep it practical — I want it working, not a lecture on functions.
Replace these placeholders with your own values: