If you find yourself typing the same lookup table into Excel every time you build a Dungeons & Dragons character, you are doing more data entry than roleplaying. That Reddit user asking for a formula to convert ability scores into modifiers is not looking for a spreadsheet lesson, they are looking for a tool that understands what they actually want to accomplish. The real problem here is not that Excel cannot do it. The problem is that Excel makes you think like a programmer before you can play like a storyteller.
The request is simple enough: take a number between 1 and 20, and map it to a modifier that follows the 5e rules. In Excel, that means nesting IF statements or building a VLOOKUP table. Neither is hard for someone who has spent hours inside spreadsheets. But for the Dungeon Master who just wants to level up their party, those extra steps are friction. They interrupt the creative flow. The user had to ask a forum for help, then wait for replies, then test the formula, then hope it worked. That is not automation. That is outsourcing your mental load to strangers.
What an AI-native spreadsheet does differently is understand the intent behind the question. Instead of asking you to define every possible range with a formula, it can infer the pattern from a few examples. You tell it that 1 through 4 equals 2, 5 through 8 equals 3, and so on. The spreadsheet recognizes the stepwise mapping and applies it instantly. No nested IFs. No manual lookup tables. No Reddit posts. The tool adapts to your thinking, not the other way around.
This matters beyond D&D. The same principle applies to any repetitive data transformation, scoring rubrics, tax brackets, pricing tiers, performance ratings. Every time you find yourself writing a formula that maps ranges to values, you are doing work that a spreadsheet should handle for you. The question is not whether Excel can do it. It can. The question is whether the tool should make you ask for help to do something so straightforward. An AI-native spreadsheet would have answered that user in one sentence: "Tell me the ranges you need, and the spreadsheet will handle the rest." That is the future of data management, one where the tool meets you where you are, not where it expects you to be.