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

I am not sure how to fix this.

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

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

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

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

Good to see, and thanks for the response.


Kyla2000 Wrote:
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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=531705

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

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.