3

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")

 

Functionality
Department

Comments

You are actually very close, just missing some end parenthesis

=IF(AND(FIND("$",[Creation]4)>0,FIND("$",[Clos]7)>0),"TRUE","FALSE")

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.