Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Strange IF conditonal problem (Excel 2000/SR1)

    Look at the attached workbook, sheet "Tables", cell I15. it contains an IF condition that works in reverse for some reason. Can anyone tell me what is wrong here?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Strange IF conditonal problem (Excel 2000/SR1)

    Your columns of "numbers" are TEXT not numbers.

    Highlight C12:c19, data - text to columns - delimited -finish
    Highlight D1219, data - text to columns - delimited -finish

    Now they will be numbers and your formula works

    Steve

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

    Re: Strange IF conditonal problem (Excel 2000/SR1)

    The cells in columns C and D are not seen as numbers by Excel. This is a problem that crops up regularly, in particular if the cells have been imported from another application.

    There are several easy solutions:
    - Select the cells in column C, select Data/Text to Columns, click Finish. Repeat for the cells in column D.
    - Or select an empty cell and copy to the clipboard; then select C1219, and select Edit/Paste Special..., option Add, OK.

  4. #4
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Strange IF conditonal problem (Excel 2000/SR1)

    Super thanks!! I asked the person who had created this template and sure enough those cells had been imported from a word doc.

Posting Permissions

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