14,974
edits
Google spreadsheet: Difference between revisions
Jump to navigation
Jump to search
→步驟2. 使用函式，分析使用者的作答結果
| Line 103: | Line 103: | ||
<td>牛奶, 巧克力</td> | <td>牛奶, 巧克力</td> | ||
<td></td> | <td></td> | ||
<td> =IF( REGEXMATCH(B2, $E$2) = TRUE, 1, 0) </td> | <td><div style="background-color: yellow"> =IF( REGEXMATCH(B2, $E$2) = TRUE, 1, 0) </div></td> | ||
<td> =IF( REGEXMATCH(B2, $F$2) = TRUE, 1, 0) </td> | <td><div style="background-color: yellow"> =IF( REGEXMATCH(B2, $F$2) = TRUE, 1, 0) </div></td> | ||
<td> =IF( REGEXMATCH(B2, $G$2) = TRUE, 1, 0) </td> | <td><div style="background-color: yellow"> =IF( REGEXMATCH(B2, $G$2) = TRUE, 1, 0) </div></td> | ||
</tr> | </tr> | ||
</table> | </table> | ||