Using If AND FIND formulas together
I am trying to use if and find formula to look some letters in strings at the different cells. And if they match with each other I want to give output as "TRUE" and they don't I want to say "False".
For example I am looking $ sign in different rows and if they match I want to have output as "TRUE" and If they don't "FALSE". How can I do this?
=IF(AND(FIND("$",[Creation]4>0,FIND("$",[Clos]7>0,"TRUE","FALSE")
Comments

You are actually very close, just missing some end parenthesis
=IF(AND(FIND("$",[Creation]4)>0,FIND("$",[Clos]7)>0),"TRUE","FALSE")

Thank you Very Much. I was stressing it over more than 3 hours.

The only things missing were that you forgot to close out both of your FIND functions as well as your AND function. That's all.