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

[Kyla2000]

I am not sure how to fix this.

[Bryan Hessey]

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")

--

I am not sure how to fix this.

[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
>
>

[Bryan Hessey]

Good to see, and thanks for the response.

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
>
>

[Jerry W. Lewis]

A formula like
=(cell1-cell2)
will show why Bryan's solution was needed (note that the parentheses are
requrired).

Jerry

"Kyla2000" wrote:

> I am not sure how to fix this.