Closed Thread
Results 1 to 5 of 5

My IF statement is stating False but if I manual calculate it it

Hybrid View

  1. #1
    Kyla2000
    Guest

    Re: My IF statement is stating False but if I manual calculate it

    Thank you Bryan,

    The rounding was the issue.

    Thanks Again.
    Lisa

    "Bryan Hessey" wrote:

    >
    > Not much information to go on, can you post the statement?
    >
    > If you are comparing two amounts, try comparing as
    > =If(Round(A1,2)=Round(A2,2),"True","False")
    >
    > --
    >
    > Kyla2000 Wrote:
    > > I am not sure how to fix this.

    >
    >
    > --
    > Bryan Hessey
    > ------------------------------------------------------------------------
    > Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
    > View this thread: http://www.excelforum.com/showthread...hreadid=531705
    >
    >


  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Good to see, and thanks for the response.


    Quote Originally Posted by Kyla2000
    Thank you Bryan,

    The rounding was the issue.

    Thanks Again.
    Lisa

    "Bryan Hessey" wrote:

    >
    > Not much information to go on, can you post the statement?
    >
    > If you are comparing two amounts, try comparing as
    > =If(Round(A1,2)=Round(A2,2),"True","False")
    >
    > --
    >
    > Kyla2000 Wrote:
    > > I am not sure how to fix this.

    >
    >
    > --
    > Bryan Hessey
    > ------------------------------------------------------------------------
    > Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
    > View this thread: http://www.excelforum.com/showthread...hreadid=531705
    >
    >

Closed 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