https://spreadsheetpoint.com/regexmatch-function-google-sheets/
Regexmatch() returns TRUE if expression matches, FALSE if it doesn't.
Syntax like
=if(regexmatch(D20,"NANDA"),if(regexmatch(D20,"LIFE"),G20,0),0)
means that the cell value would equal G20 if it matches both conditions, and 0 if it doesn't.
https://support.google.com/docs/answer/3093364?hl=en
IF(logical_expression, value_if_true, value_if_false)
No comments:
Post a Comment