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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives