Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    data type and calculations (Excel 2000)

    Hi Everyone,

    Any ideas how I get around the following error: #VALUE!
    I am trying to add cells and sometimes the cell may have text in it - so basically I want to ignore the contents however sometimes it may have numeric data, so I want to add it.

    Thanks Kindly,

    Kerrie [img]/forums/images/smilies/smile.gif[/img]

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: data type and calculations (Excel 2000)

    I have just summed 6 cells, 5 having numbers and 1 having text. It did not seem to matter if there was ALSO a number within that text. Perhaps there's some other problem. Can you give us an exact scenario?

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: data type and calculations (Excel 2000)

    When you use a formula like
    =A1+B3+C5
    it results in #VALUE if one or more of the cells contain text.
    When you use
    =SUM(A1,B3,C5)
    Excel will ignore cells with text and just add the numeric cells.

  4. #4
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: data type and calculations (Excel 2000)

    Thank you HansV

    [img]/forums/images/smilies/smile.gif[/img]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •