Please enable JavaScript to view the comments powered by Disqus.

IF(...SUMPRODUCT(...--(...A2:C2="")),"Blank","All Filled")

Check if row contains empty cells

Looks at the specified cells in the row and return whether all of them are filled or not

Used Functions

Category: Logical

Specifies a logical test to perform


IF(Something is True, then do something, otherwise do something else)

Category: Math and trigonometry

Returns the sum of the products of corresponding array components


SUMPRODUCT(array1, [array2], [array3], ...)

Lets chat on this