(solved) Easy IF formula to identify blank fields

[Raik_Brauns]

This should be an easy one for you experts :frowning:
I try to write a formula for the following case:
I want to write the Value “Team” in a Field1 IF Field2 And Field3 And Field4 are not empty!

PLEASE help me!

[Elias_Gomez_Sai]

IF(AND(1,2,3), 'Team').

Of course change the 1,2,3 to your actual field names.

[Raik_Brauns]

no blank() check required? I’ll try …

[Elias_Gomez_Sai]

Checking 3 not blank fields is the same as checking the 3 exist.

[Raik_Brauns]

Elias_Gomez_Sainz:

IF(AND(1,2,3), ‘Team’)

Works great … lesson learned. Thanks so much!