IF(...)
Check if row contains empty cells
Used Functions
Category: Logical
Specifies a logical test to perform
Syntax
IF(Something is True, then do something, otherwise do something else)
Practice IF Formula at Sheetzoom
IF formula at Microsoft helpCategory: Math and trigonometry
Returns the sum of the products of corresponding array components
Syntax
SUMPRODUCT(array1, [array2], [array3], ...)
0
Looks at the specified cells in the row and return whether all of them are filled or not