Well I was working with the Exact Function in Excel 2007 and wondering why I am getting a two different results?

Lets Have a "Word" in one cell(Say A1) and "word" in other cell.(Say A2)

Use the Formula "=Exact(A1,A2)" and the answer should be false and it makes sense as the Exact Function is Case Sensitive.

Now in Cell B1 put this formula "=Propoer(A1)" and result should be "Word"

Cell B2 --- "=Proper(A2)" and result "Word"

and Cell B3 --- "=Exact(b1,b2)" result will be True

But when the try to combine the three Forumlas B1,B2,B3 in to one Like

in cell A4 use this formula "=Exact(proper(A1),proper(A2))" it give a result False..

Any one know the reasoning behind this?