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