Embedded Files
RANge-based CONditional Functions
IF
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
=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
=IFERROR(DATEDIF($I$1, DATE($A4,B$2,7),"Y"),"-")
IFNA
IFNA
=IFNA(value, value_if_na)
ISNA
ISNA
=ISNA(A1)
Returns TRUE or FALSE
SWITCH
SWITCH
=SWITCH(A2, "O", "Oracle", "M", "MySQL", "S", "SQL Server", "Other")
=SWITCH(A2, "O", "Oracle", "M", "MySQL", "S", "SQL Server", A2)
Bibliography
Bibliography
https://stackoverflow.com/questions/30842607/excel-formula-like-and-if-wildcards
IFhttps://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2https://www.reddit.com/r/excel/comments/10hy9pd/how_do_i_make_a_cell_automatically_fill_itself/https://stackoverflow.com/questions/66760820/google-sheet-issue-in-if-function-with-array-formula
IFShttps://www.reddit.com/r/excel/comments/10hy9pd/how_do_i_make_a_cell_automatically_fill_itself/https://support.microsoft.com/en-gb/office/ifs-23c84e31-fc11-425d-ab03-5630f247b566
IFERRORhttps://blog.sheetgo.com/google-sheets-formulas/iferror-formula-google-sheets/
IFNAhttps://exceljet.net/functions/ifna-function
ISNAhttps://exceljet.net/functions/isna-function
SWITCHhttps://www.statology.org/case-statement-google-sheets/https://www.statology.org/case-statement-in-excel/
IFhttps://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2https://www.reddit.com/r/excel/comments/10hy9pd/how_do_i_make_a_cell_automatically_fill_itself/https://stackoverflow.com/questions/66760820/google-sheet-issue-in-if-function-with-array-formula
IFShttps://www.reddit.com/r/excel/comments/10hy9pd/how_do_i_make_a_cell_automatically_fill_itself/https://support.microsoft.com/en-gb/office/ifs-23c84e31-fc11-425d-ab03-5630f247b566
IFERRORhttps://blog.sheetgo.com/google-sheets-formulas/iferror-formula-google-sheets/
IFNAhttps://exceljet.net/functions/ifna-function
ISNAhttps://exceljet.net/functions/isna-function
SWITCHhttps://www.statology.org/case-statement-google-sheets/https://www.statology.org/case-statement-in-excel/
Page updated
Google Sites
Report abuse