Google spreadsheet: Difference between revisions
| Line 60: | Line 60: | ||
<pre> | <pre> | ||
=IF( REGEXMATCH(B2, "香草") = TRUE, 1, 0) | =IF( REGEXMATCH(B2, "香草") = TRUE, 1, 0) | ||
或改成使用儲存格的絕對參照位址 $E$2 | |||
=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) | ||
或改成使用儲存格的絕對參照位址 $E$2 | |||
=IF( REGEXMATCH(B2, $E$2) = TRUE, 1, 0) | |||
</pre> | </pre> | ||