Skip to Main Content
nozenfordaddy (
nozenfordaddy
) wrote
in
sheikah
2012-06-13 03:09 pm (UTC)
no subject
Try =IF(cell with word=word, number if true, number if false)
So like:
=IF(A1=TRUE, 1, 0)
If that doesn't work, or your word is more complex, you may need to put "quotations" so it would be:
=IF(A1="Answer positive", 1, 0)
Unless you've already tried that in which case I've no idea why it didn't work...
(
5 comments
)
Post a comment in response:
From:
Anonymous
This account has disabled anonymous posting.
OpenID
Identity URL:
Log in?
Dreamwidth account
Account name
Password
Log in?
If you don't have an account you can
create one now
.
Subject
HTML doesn't work in the subject.
Formatting type
Casual HTML
Markdown
Raw HTML
Rich Text Editor
Message
Log in
Account name:
Password:
Remember me
Other options:
Forget your password?
Log in with OpenID?
Close
menu
Log in
Create
Create Account
Display Preferences
Explore
Interests
Directory Search
Site and Journal Search
Latest Things
Random Journal
Random Community
FAQ
Shop
Buy Dreamwidth Services
Gift a Random User
DW Merchandise
Interest
Region
Site and Account
FAQ
Email
no subject
So like:
=IF(A1=TRUE, 1, 0)
If that doesn't work, or your word is more complex, you may need to put "quotations" so it would be:
=IF(A1="Answer positive", 1, 0)
Unless you've already tried that in which case I've no idea why it didn't work...