+ Reply to Thread
Results 1 to 3 of 3

IF function returning incorrect result

  1. #1
    Hillary E.
    Guest

    IF function returning incorrect result

    I am trying to perform what I think should be a simple function - trying to
    convert an alpha character to a specified numeric value. I have a column that
    contains either a C, E or N that I need to assign a numeric value to as
    follows: C=1, E or N=0. I My column header (A1) is C and I am using the IF
    function to do this conversion. The function popup window it is putting the
    correct result but when I press okay the wrong value is displayed. For
    example my value in A2 is C, so I set the formula up to say if A2=A1 is true,
    value returned should be 1, if A2=A1 is false, value returned should be 0.
    The formula is telling me that this is a true statement, but it keeps
    returning the false value of 0. I am on Windows 2000 Professional with Excel
    2002. This should be a simple conversion, but it will not work and it is
    driving me crazy. I am sure I must be doing something obviously wrong. Is it
    because I am attempting to compare text to text with the = sign? Any help or
    suggestions would be greatly appreciated. Thanks!



  2. #2
    Don Guillett
    Guest

    Re: IF function returning incorrect result

    as ALWAYS, post your efforts for comments

    --
    Don Guillett
    SalesAid Software
    dguillett1@austin.rr.com
    "Hillary E." <HillaryE@discussions.microsoft.com> wrote in message
    news:BA8E8131-7F1A-4276-A20B-F629AB95F69E@microsoft.com...
    >I am trying to perform what I think should be a simple function - trying to
    > convert an alpha character to a specified numeric value. I have a column
    > that
    > contains either a C, E or N that I need to assign a numeric value to as
    > follows: C=1, E or N=0. I My column header (A1) is C and I am using the IF
    > function to do this conversion. The function popup window it is putting
    > the
    > correct result but when I press okay the wrong value is displayed. For
    > example my value in A2 is C, so I set the formula up to say if A2=A1 is
    > true,
    > value returned should be 1, if A2=A1 is false, value returned should be 0.
    > The formula is telling me that this is a true statement, but it keeps
    > returning the false value of 0. I am on Windows 2000 Professional with
    > Excel
    > 2002. This should be a simple conversion, but it will not work and it is
    > driving me crazy. I am sure I must be doing something obviously wrong. Is
    > it
    > because I am attempting to compare text to text with the = sign? Any help
    > or
    > suggestions would be greatly appreciated. Thanks!
    >
    >




  3. #3
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    What formula are you trying? Perhaps you just need

    =(A2=A$1)+0

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1