15,017
edits
Google spreadsheet: Difference between revisions
Jump to navigation
Jump to search
→問卷作答結果的分析
| Line 112: | Line 112: | ||
<td>牛奶, 巧克力</td> | <td>牛奶, 巧克力</td> | ||
<td></td> | <td></td> | ||
<td><div style="background-color: yellow"> =IF( REGEXMATCH(B2, $E$2) = TRUE, 1, 0) </div></td> | <td><div style="background-color: yellow"> =IF( REGEXMATCH(B2, $D$2) = TRUE, 1, 0) </div></td> | ||
<td><div style="background-color: yellow"> =IF( REGEXMATCH(B2, $E$2) = TRUE, 1, 0) </div></td> | |||
<td><div style="background-color: yellow"> =IF( REGEXMATCH(B2, $F$2) = TRUE, 1, 0) </div></td> | <td><div style="background-color: yellow"> =IF( REGEXMATCH(B2, $F$2) = TRUE, 1, 0) </div></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||