CONTAINS a blank in region

andihawes08

Id like to create a formula that looks across 5 or so rows, that can report if any are blank. Ive tried to use CONTAINS but it doesnt appear to work when i use "" to signify finding a blank cell.

Online Help seems to suggest that i need to use IF with CONTAINS to gain my result. Do i? I get something to work with bu doesnt seem to take accpount of my "" to signify BLANK?

Any tips?

John Jonassen

Not knowing what you have tried, @andihawes08 , here is what works for me:

=IF([Andihawes' Column]@row = "", "FLAG", "")

Then update it with the correct name of your column and what you would like to return if the cell is blank.