Google spreadsheet: Difference between revisions
| Line 60: | Line 60: | ||
<pre> | <pre> | ||
=IF( REGEXMATCH(B2, "香草") = TRUE, 1, 0) | =IF( REGEXMATCH(B2, "香草") = TRUE, 1, 0) | ||
或 =IF( REGEXMATCH(B2, $E$2) = TRUE, 1, 0) | |||
</pre> | </pre> | ||
| Line 60: | Line 60: | ||
<pre> | <pre> | ||
=IF( REGEXMATCH(B2, "香草") = TRUE, 1, 0) | =IF( REGEXMATCH(B2, "香草") = TRUE, 1, 0) | ||
或 =IF( REGEXMATCH(B2, $E$2) = TRUE, 1, 0) | |||
</pre> | </pre> | ||