Google spreadsheet: Difference between revisions
Jump to navigation
Jump to search
← Older edit
Newer edit →
Google spreadsheet
(edit)
Revision as of 09:24, 28 April 2014
45 bytes added
,
28 April 2014
m
→步驟2. 使用函式,分析使用者的作答結果
Revision as of 23:29, 27 April 2014
(
edit
)
Planetoid
(
talk
|
contribs
)
m
(
→步驟2. 使用函式,分析使用者的作答結果
)
← Older edit
Revision as of 09:24, 28 April 2014
(
edit
)
(
undo
)
Planetoid
(
talk
|
contribs
)
m
(
→步驟2. 使用函式,分析使用者的作答結果
)
Newer edit →
Line 60:
Line 60:
<pre>
<pre>
=IF( REGEXMATCH(B2, "香草") = TRUE, 1, 0)
=IF( REGEXMATCH(B2, "香草") = TRUE, 1, 0)
或 =IF( REGEXMATCH(B2, $E$2) = TRUE, 1, 0)
</pre>
</pre>
Planetoid
Bureaucrats
,
Administrators
14,974
edits
Navigation menu
Personal tools
Not logged in
Talk
Contributions
Log in
Namespaces
Page
Discussion
English
Views
Read
Edit
View history
More
Search
Navigation
Main page
Current events
Recent changes
Random page
Help
Categories
Tools
Special pages
Printable version