Needed: Formula to identify if any 1 of 3 colums identified are blank... thanks!

See example spreadsheet attached... I would like the equation to populate 'Complete' if all identified columns are have data, and 'Incomplete' if any of the 3 identified columns have been left blank.

Thanks in advance for your help!

Prodetik

You can use this in Q2:

=IF(COUNTA(J2,N2,P2)=3,"Complete","Missing data")

Hope this helps.

Pete

Brilliant... thanks, again, Pete!

Prodetik

You're welcome - thanks for feeding back.

Pete