I am a newbie and need a bit help w formulas in lotus approach.
What I am trying to do is IF field A is blank to have the data from field B entered in field A,otherwise, to leave field A as is. Also, IF field B is blank (A is blank too), I want contents in field C to be entered in field A.
I tried something like the following but am not successful, obviously. I really appreciate any help anyone can give me. Thanks a million in advance.
If(IsBlank(field_A), (Fill(field_B),(otherwise leave this))
What I am trying to do is IF field A is blank to have the data from field B entered in field A,otherwise, to leave field A as is. Also, IF field B is blank (A is blank too), I want contents in field C to be entered in field A.
I tried something like the following but am not successful, obviously. I really appreciate any help anyone can give me. Thanks a million in advance.
If(IsBlank(field_A), (Fill(field_B),(otherwise leave this))