Using If AND FIND formulas together

ABHI · 07/03/19

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

L_123 · 07/03/19

You are actually very close, just missing some end parenthesis

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

ABHI · 07/03/19

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

Paul Newcome · 07/03/19

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.

Using If AND FIND formulas together

Comments

Categories