• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Fixing the #VALUE! Error

In the cell you want to use as the resultant cell, type the formula you want to use in your calculation. For example, type =SUM(B2+B3+B4+B5) in cell B7, and press Enter.

In this case, you get the #VALUE! error because the value in cell B2 is textual, not numeric. You won't get the error if you enter =SUM(B2:B5) instead of the plus signs.

Click on the resultant cell (here, B7), press F2 on the keyboard, and retype the formula—in this case, =SUM(B3+B4+B5)—and press Enter.

The error disappears because all cells are numeric.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint