True/False formula?
I'm trying to figure out a formula to note a "1" in the cell if the information in the cell next to it is a certain value, any other value needs to show a "0". Is this a "true/false" formula?
I figured this out: =IF([Question 1]@row = "2. I should avoid using the electronic device during the initial connection; however, should use the device to log the information discussed prior to leaving the patient's room", 1, "1") however when copying the formula to additional cells, it's showing the "1" for everything instead of those that only show the desired information. I"m missing the 2nd part...thanks!
Best Answer
-
@Jillian M an IF statement will do what you need.
=if([Column Name]@row="Value",1,0)
Answers
-
@Jillian M an IF statement will do what you need.
=if([Column Name]@row="Value",1,0)
-
Amazing! Thank you for being so quick to respond. #learnsomethingneweveryday
-
@JamesB Now I need a similar formula to state if a cell is "4" or greater to state "Pass", if 3 or less, then "Fail". Suggestions?
Nevermind :-) I figured it out! :-)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives