I want to write the function:
If (Field 1 = 50 ; No ; Yes)
For some reason I can not go from number to text. I can write the If( Field 1 = yes ; 50 ; 0), why can't you write an If field from number to text?
This is the correct sequenze:
1) Create a field with the name Field 1
2) Create the calculation field that use in its calc the Field 1
If ( Field 1 = 50 ; "No" ; "Yes" )
Text results must be quoted.
This is what I wrote If ( Field 1 ; "Yes" ; "No" ) the message reads "The specified field can not be found". Any suggestions?
Sounds like 'Field 1' doesn't exist, or can't be found. Are you using the function in a calculated field, or script?
Do you have a field named Field 1 ?
I just created the field to write the If function. Do I need to create the field first before turning it into a calculation?
I figured it out. I wasn't selecting the field, just typing it in didn't work. Thanks!
Retrieving data ...