Sometimes, when you enter a formula, Excel displays a value that begins with a hash mark or pound sign (#). This is a signal that the formula is returning an error value. You have to correct the formula (or correct a cell that the formula references) to get rid of the error display.

In some cases, Excel won’t even let you enter an erroneous formula. For example, the following formula is missing the closing parenthesis:

 =A1*(B1+C2

If you attempt to enter this formula, Excel informs you that you have unmatched parentheses, and it proposes a correction. Often, the proposed correction is accurate, but you can’t count on it.

Last modified: Sunday, 28 June 2020, 9:26 PM
Accessibility
Reset All

Background Colour Background Colour

Font Face Font Face

Font Kerning Font Kerning

Font Size Font Size

1

Image Visibility Image Visibility

Letter Spacing Letter Spacing

0

Line Height Line Height

1.2

Link Highlight Link Highlight

Text Alignment Text Alignment

Text Colour Text Colour