SS Conditional Functions

RANge-based CONditional Functions

IF

=IF(A1=B1,"TRUE","FALSE")

=IF(W501=I501,0,MIN(SUMIF($A$3:$A$478,$Y501,V$3:V$478),$I501))

IF the value in W501 is equal to the value in I501 then set the value of the current cell to 0.IF the values don't match then set the value of the current cell to the result of the RACON function (which SUMs values in a range of values from column V based on a lookup within a range of values in column A using the value in column Y of the current row as the key) or the value of column I of the current row, whichever is lower.

=IF(H8>9,"Critical",IF(H8>7,"High",IF(H8>4,"Medium",IF(H8>0,"Low","None"))))

Shows a decriptive rating for a CVSS 3.1 score in H8. See also IFS (below)

IFS

=IFS(H8>9,"Critical",H8>7,"High",H8>4,"Medium",H8>0,"Low","None")

Shows a decriptive rating for a CVSS 3.1 score in H8. See also IF (above)

IFERROR

=IFERROR(DATEDIF($I$1, DATE($A4,B$2,7),"Y"),"-")

IFNA

=IFNA(value, value_if_na)

ISNA

=ISNA(A1)

Returns TRUE or FALSE

SWITCH

=SWITCH(A2, "O", "Oracle", "M", "MySQL", "S", "SQL Server", "Other")

=SWITCH(A2, "O", "Oracle", "M", "MySQL", "S", "SQL Server", A2)

Bibliography