When you see the #VALUE error, it means that there is something wrong with the way the formula is typed, or there is something wrong with the cells you are referencing.

For many, Microsoft Excel is the epitome of corporate drudgery. It's dreaded #VALUE! error has driven an incalculable number of users to despair.

Last month Microsoft introduced an AI assistant for Excel which lets users crunch data using natural-language prompts. Excel, and its faithful, aren’t ready to be filtered out just yet.