Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Formula Gives Wrong Result (97)

    I have a worksheet (attached) with a value of 1 in cell F2. It is a number and not a label and it is exactly 1. The formula I have in cell G2 is:

    =IF(F2>5,"Yes","No")

    Since F2 is 1, this should return "No" but it returns "Yes"! If I copy it down the column, it returns the wrong results for all the numbers. I can't figure this one out. Any help is appreciated.
    Attached Files Attached Files
    Ronny Richardson

  2. #2
    Lounger
    Join Date
    Nov 2001
    Location
    SF Bay Area
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Gives Wrong Result (97)

    I don't know WHY it is behaving this way, but I see if you re-enter the number in column F the calculation is correct. It also fixed it when I did a Find and Replace, whole cells only, of the number -- I did it by column and replaced all. It looks like you don't have anything higher than a 10, so it shouldn't take more than a few minutes to correct. Hopefully, someone will know what caused this misbehavior.

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Formula Gives Wrong Result (97)

    Whilst the value in F2 is a number, it is not regarded as numeric by excel for whatever reason. There are a number of colums with the same problem. To set things right follow these steps :-

    Select a blank cell, say G3
    Copy it
    Press F5 (GoTo)
    Select Special,
    Select Constants
    When the selection is made go to Edit Paste Special and select Add

    Your formula should now return the correct result.

    Andrew C

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Formula Gives Wrong Result (97)

    I had not thought of search-and-replace but it does seem to work. Thanks.

    Ronny
    Ronny Richardson

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Formula Gives Wrong Result (97)

    This is a great fix, thanks.

    Ronny
    Ronny Richardson

Posting Permissions

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