(solved) Easy IF formula to identify blank fields


#1

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!


#2

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

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


#3

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


#4

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


#5

Works great … lesson learned. Thanks so much!