Thread: My IF statement is stating False but if I manual calculate it it
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bryan Hessey
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote