Forum Discussion
If Condition in Two Rows is met, then give a result
I have the following data table: I am trying to get a result to display based on the results of both Condition 1 and Condition 2. They are calculated columns as follows: Condition...
vanessafvg
Community Champion
Community Championcan you try, and what do you get?
Condition 2 =
IF (
MDD[Test 7] = "True"
&& MDD[In] = "True"
&& MDD[Less than -10] = "True",
1
)
Here is the column I added (named Condition 3 because I already have a Condition 2),
Condition 3 = IF(
MDD[Test 7] = "True" &&
MDD[In] = "True" &&
MDD[Less than -10] = "True",
1)
And that gave me a whole number count. The table has the following result: