True/False formula?

Jillian M

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!

JamesB

@Jillian M an IF statement will do what you need.

=if([Column Name]@row="Value",1,0)

JamesB

@Jillian M an IF statement will do what you need.

=if([Column Name]@row="Value",1,0)

Jillian M

Amazing! Thank you for being so quick to respond. #learnsomethingneweveryday

Jillian M

@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! :-)