Google spreadsheet: Difference between revisions

Google spreadsheet (edit)

14 bytes removed , 27 April 2014

m

14,974

edits

@@ Line 97: / Line 97: @@
    <td>牛奶, 巧克力</td>
    <td></td>
-   <td> =IF( REGEXMATCH(B2, "香草") = TRUE, 1, 0) </td>
+   <td> =IF( REGEXMATCH(B2, $E$2) = TRUE, 1, 0) </td>
-   <td> =IF( REGEXMATCH(B2, "牛奶") = TRUE, 1, 0) </td>
+   <td> =IF( REGEXMATCH(B2, $F$2) = TRUE, 1, 0) </td>
-   <td> =IF( REGEXMATCH(B2, "巧克力") = TRUE, 1, 0) </td>
+   <td> =IF( REGEXMATCH(B2, $G$2) = TRUE, 1, 0) </td>
 </tr>
 </table>
 === 步驟3. 加總分析結果 ===
 最後我們只要把香草分析結果的數字，加總(sum)即可得到喜愛香草的數量。