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

Syntax

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

Syntax

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

Lets chat on this