Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.| support.microsoft.com
Formulas can sometimes result in error values in addition to returning unintended results. Learn about best practices to avoid those problems.| support.microsoft.com
You can use error checking to detect errors in formulas. The rules don't guarantee error-free worksheets, but they can help find common mistakes. Errors can include: Cells containing formulas that result in an error, inconsistent calculated column formula in tables, cells containing years represented as 2 digits, numbers formatted as text or preceded by an apostrophe, formulas inconsistent with other formulas in the region, formulas which omit cells in a region, unlocked cells containing form...| support.microsoft.com