Hi All. I feel like there is an easy answer to this one; I've been trying nested formulas but I can't get it right.
I want to do an IF/AND statement that will produce one of 3 outcomes.
This is what the final results should look like: first 2 rows are values. 3rd row is the result I want.
<tbody>
</tbody>
Basically I want this: if you subtract the first 2 rows, you will get a result.
If the result is less than 40%, and the value in the first row is less than 40%, return NA
If the result is less than 40% and the value in the first row is greater than 40%, return YES
If the result is greater than 40% and the value in the first row is greater than 40%, return NO
Any help you can provide would be appreciated.
I want to do an IF/AND statement that will produce one of 3 outcomes.
This is what the final results should look like: first 2 rows are values. 3rd row is the result I want.
20% | 50% | 90% |
10% | 20% | 10% |
NA | Yes | No |
<tbody>
</tbody>
Basically I want this: if you subtract the first 2 rows, you will get a result.
If the result is less than 40%, and the value in the first row is less than 40%, return NA
If the result is less than 40% and the value in the first row is greater than 40%, return YES
If the result is greater than 40% and the value in the first row is greater than 40%, return NO
Any help you can provide would be appreciated.