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
Thankyou in advance for any suggestions