Lani Vriezema
asked on
Need help with a formula, if a field contains a word then yes, else no
If a field contains "Foreman"
then "Y"
Else "N"
then "Y"
Else "N"
ASKER
I don't think that would work because of the data:
Here is an example
Labor Group Foreman
Labor Group 3 Foreman
Labor Group 5 Foreman
Here is an example
Labor Group Foreman
Labor Group 3 Foreman
Labor Group 5 Foreman
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Another idea
If (InStr({YourField}, 'Foreman') Then
'Y'
Else
'N'
If (InStr({YourField}, 'Foreman') Then
'Y'
Else
'N'
if {your database field} = 'Foreman' then
'Y'
else
'N'
Replace {your database field} with your actual database field.