Share via

Microsoft Excell

Anonymous
2019-05-30T14:04:42+00:00

If I +E4+E5 in Excell it gives #Value in the other cell??? Please help

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2019-05-30T14:53:47+00:00

    Usually, it means that one or both of E4 and E5 are text that Excel cannot interpret as a number.

    Use =ISTEXT(E4) and =ISTEXT(E5) to confirm.

    [EDIT] Better:  =ISNUMBER(--E4) and =ISNUMBER(--E5).  Note the double negate ("--"). If FALSE, Excel cannot interpret E4 and/or E5 as a number.

    You cannot rely on visual inspection or cell format.  We can enter text into cells that have a numeric format (anything but Text). 

    And looks can be deceiving; for example, the text might include non-breaking  spaces (ASCII 160; HTML nbsp), which we cannot see.

    If you expect text sometimes and you simply want the formula to work sensibly, enter the formula =SUM(E4,E5) instead.

    Was this answer helpful?

    0 comments