The #REF! error occurs in MS Excel when a formula refers to a cell that is not valid. MS Excel displays #DIV/0! error when a formula tries to divide a number by 0 or an empty cell.Ĭhange the value of cell A2 to a value that is not equal to 0 or you can also use function like IF to prevent the error from being displayed. Use a SUM function so that it can ignore cells that contain text. To resolve this issue, you can perform either of the followingġ. As shown in the figure below, where the formula refers to adding cell A1 A2 and A3, however, since the value in A2 is a non-number value therefore, the result occurs as an error “#VALUE!”. This error occurs when a data type mismatches.

Correct the mistake and the function will work as shown in the figure below. So the result occurred as a #NAME? error. As shown in the figure below where the desired formula was SUM however, by mistake, there is an underscore next to the range. The #NAME? Error refers to any misspelled function or a wrong function. This error occurs when an incorrect formula or function is called in MS Excel formula. You can also expand it by double clicking the border. Now, to resolve this issue, click on the right border of the column A header as shown in the above figure, and drag it towards right increase the column width. When you encounter a situation where your cell display # signs instead of the actual values, it means your column width is not appropriate and you need to expand.

This tutorial will be covering frequently occurring formula errors which you may encounter while using MS Excel. Therefore, it also has a well-crafted error handling method in place. MS Excel provides complete support to its users for an excellent computing experience.

Ms excel formula results not displaying