14,974
edits
Google spreadsheet: Difference between revisions
Jump to navigation
Jump to search
m
→步驟2. 使用函式，分析使用者的作答結果
| 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> | ||