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
-
JamesB ✭✭
@Jillian Man IF statement will do what you need.
=if([Column Name]@row="Value",1,0)
Answers
-
JamesB ✭✭
@Jillian Man 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
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/107937/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/107937/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>