+ Reply to Thread
Results 1 to 2 of 2

IF function comare to identical amount but inconsistent results

  1. #1
    Registered User
    Join Date
    07-28-2006
    Posts
    2

    IF function comare to identical amount but inconsistent results

    I tried to compare the amount of 2 colums (10 rows) because and ithey are the same amount extracted from 2 different sources.
    Here is my function =IF(B7=E7,TRUE,False)

    Some rows came out to be True, however, I get some "False" results and when I eye-balled the two amounts, they are identical. So I am not sure why two identical amounts would give me "false" results. I tried to format both columns to 2 decimal places and it still doesn't work.
    Can someone please tell me how to fix this problem?
    Thanks so much.

  2. #2
    Ragdyer
    Guest

    Re: IF function comare to identical amount but inconsistent results

    For the *same* reason as this:

    http://www.mcgimpsey.com/excel/pennyoff.html

    --
    HTH,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------
    "skhuon" <[email protected]> wrote in
    message news:[email protected]...
    >
    > I tried to compare the amount of 2 colums (10 rows) because and ithey
    > are the same amount extracted from 2 different sources.
    > Here is my function =IF(B7=E7,TRUE,False)
    >
    > Some rows came out to be True, however, I get some "False" results and
    > when I eye-balled the two amounts, they are identical. So I am not sure
    > why two identical amounts would give me "false" results. I tried to
    > format both columns to 2 decimal places and it still doesn't work.
    > Can someone please tell me how to fix this problem?
    > Thanks so much.
    >
    >
    > --
    > skhuon
    > ------------------------------------------------------------------------
    > skhuon's Profile:
    > http://www.excelforum.com/member.php...o&userid=36902
    > View this thread: http://www.excelforum.com/showthread...hreadid=566176
    >



+ 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