Google spreadsheet: Difference between revisions

Google spreadsheet (edit)

No change in size , 4 March 2015

m

15,017

edits

@@ Line 112: / Line 112: @@
    <td>牛奶, 巧克力</td>
    <td></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, $D$1) = 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, $E$1) = 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$1) = TRUE, 1, 0) </div></td>
 </tr>
 <tr>