link two custom filed together

[Majid]

Hello Dear:
I am looking for a formula to help me out for the following senerio
I have two custom fields: "Flag 4" and "Text 17"
I want to say yes on Flag 4 when threr is any text on text 17 field other
than D-M
Please advice

 

[Majid]

Thanks John. It works!!
your help is really appreciated
Have a nice day

Hello Dear:
I am looking for a formula to help me out for the following senerio
I have two custom fields: "Flag 4" and "Text 17"
I want to say yes on Flag 4 when threr is any text on text 17 field other
than D-M
Please advice

Majid,
Put this formula in Flag4:
IIf([Text17]<>"D-M" And [Text17]<>"","yes","no")

Hope this helps.
John
Project MVP

 

[John]

Hello Dear:
I am looking for a formula to help me out for the following senerio
I have two custom fields: "Flag 4" and "Text 17"
I want to say yes on Flag 4 when threr is any text on text 17 field other
than D-M
Please advice

Majid,
Put this formula in Flag4:
IIf([Text17]<>"D-M" And [Text17]<>"","yes","no")

Hope this helps.
John
Project MVP