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], ...)
0
Looks at the specified cells in the row and return whether all of them are filled or not