Automated Excel Answer Column

I want a tidy Excel workbook that behaves like a mini-database. The user will type data into Columns C1, C2 and C3, and Column C4 must instantly show the correct result based on a set of specific rules I’ll provide. No extra clicks, no manual fills—just enter the numbers and see the answer appear.

After the main sheet is working, I also need a lightweight report: a separate tab with basic summaries and a couple of visuals so I can keep an eye on overall trends. A PivotTable or small chart that refreshes automatically is more than enough.

Please build the logic with native Excel functions—IF/IFS, INDEX-MATCH, XLOOKUP, or whatever mix does the job cleanly. If you believe a tiny macro is the simplest way to keep everything bullet-proof, I’m open to it, but I’d prefer to stay macro-free if possible.

Deliverables
• Finished .xlsx file with the C4 formula functioning on sample rows
• One reporting sheet that updates itself from new entries
• Short note that explains the rule set so I can tweak it later

If you enjoy crafting clear formulas and neat dashboards, this should be a quick and straightforward task.