We believe the student who posted this question is asking the wrong thing, not in a dismissive way, but in a way that reveals exactly where traditional spreadsheet training falls short. The request is clear: subtotals plus a conditional 15% discount. But the real problem isn't the formula. It's the tool itself. When you have to "comb the net" for a solution that should be straightforward, the spreadsheet isn't serving you. You're serving it.
This student has done the right thing by seeking help. They're trying to understand the logic, not just get an answer. That's admirable. But here's what we find striking: they explicitly say they'd rather get help than turn to AI. That instinct is understandable. Many people worry that AI will do the thinking for them, robbing them of the learning process. But the reality is more nuanced. A modern AI-native spreadsheet doesn't give you the answer and walk away. It explains the logic, shows you the steps, and lets you adapt the solution to your own data. That's not cheating. That's teaching.
The practical takeaway for anyone working through similar assignments is this: you don't have to choose between understanding and efficiency. A tool that can say, "Here's how to apply a 15% discount only to values above a certain threshold, and here's why that works," is not replacing your brain. It's extending it. The student's frustration comes from wrestling with a legacy interface that demands you memorize syntax before you can solve a problem. That's the outdated part. The goal is to get the subtotal and the discount applied correctly, and to understand why it works. That goal hasn't changed. The path to it can.
We'd encourage this student, and anyone reading, to reconsider what "turning to AI" actually means. If the AI simply spits out a formula you paste without comprehension, that's a problem. But if it walks you through the logic, asks clarifying questions, and lets you tweak the result, that's a tutor. The assignment is about learning data management, not about suffering through syntax. So by all means, keep asking questions. Keep wanting to understand. But don't let the fear of shortcuts prevent you from using a better path to the same destination. The formula you need exists. The understanding you want is within reach. The question is whether you'll let the tool help you find both.