Write a prompt so that the AI provides a ready-made Excel/Google Sheets formula for the task. The answer must contain the formula itself.
If you don’t know the formula, describe the problem in words, and AI will give you a ready-made one. Specify the columns and the condition exactly - you will get a working formula, not an approximate one.