Formula to check for blank cells

[Absfml]

Afternoon. I'm trying to use a formula to determine if any cells in a range are blank, or have text in them. For example if C2, D2, E2, F2 all have text then I need G2 to say 'complete' and if 1 does not have text in it G2 would stay blank. I've tried using 'IF' but cannot get it to work on a range of cells.

Thankyou in advance for any suggestions

 

[RoryA]

You could use something like:

=IF(COUNTA(C2:F2)<4,"","Complete")

 

[Absfml]

You could use something like:

=IF(COUNTA(C2:F2)<4,"","Complete")

Worked like a charm Rory, thanks for the assistance

 

[RoryA]

Glad we could help.