Google spreadsheet: Difference between revisions
| Line 61: | Line 61: | ||
=IF( REGEXMATCH(B2, "香草") = TRUE, 1, 0) | =IF( REGEXMATCH(B2, "香草") = TRUE, 1, 0) | ||
或改成使用香草所在的儲存格的絕對參照位址 $E$2 方便之後的維護 | |||
=IF( REGEXMATCH(B2, $E$2) = TRUE, 1, 0) | =IF( REGEXMATCH(B2, $E$2) = TRUE, 1, 0) | ||
</pre> | </pre> | ||