False Negative With "IF" Formula

[skatterbraind]

Hi everyone --

I am running a simple if formula comparing two dates in Cells A1 and B1. Cell A1 has a formula returning a date, and cell B1 has a date that was manually entered.

C1 has the formula =IF(A1=B1,1,2), and the value returned is 2, even though cells A1 and B1 have the same values.

When I replace the formula in A1 with a manually entered date, C1 returns the correct value.

I tried changing my formats in column A to general, text, and date -- none have worked. Thoughts?

 

[skatterbraind]

so stick an int in front of your formula?

yep, works perfectly, thanks again!

 

[T. Valko]

Interesting . . . the formula gives me a value of 40986.5, while the manual date returns 40986 . . .

Ok, that's your problem!

You can fix it in your formula in C1 but you might be better off fixing it at the source, X4.