How to Fix the Excel Errors #VALUE, #REF, and #NAME (Easily) Written by cofounder Kasper Langmann, Microsoft Office Specialist If you have spent much time working with formulas in Microsoft Excel, you have run into a few errors They all have a specific meaning to help you as the user understand what the problem is The formulas still won't calculate However when consulting the formula cell content, we notice that Excel adds an @ before the formula (I attached a screen shot)To resolve this error, check the formula's spelling, or use the Formula Builder to have Excel build the function for checking If the formula is spelled correctly, and your spreadsheet is still returning an error, Excel is probably getting confused over one of your entries inside the formula An easy way to fix this is to have Excel insert
Formula Errors In Excel We Make Excel Easy