Hi all,
I am analysing some survey data and I am trying to group a set number of questions together so that I can determine if a patient has rated their pain equal to or below 4 (out of 10) for ALL of the chosen questions. An example of the data is below. As well as the formula I am currently using.
The problem I have noticed is that the formula will show "ALL < = 4" even if NO data is in the cells. Logically this makes sense, but a 0 and blank cell are very different in this respect. What I need is:
IF a number is present AND it is EQUAL to or LESS than 4 in each of these cells (ATI2,ATQ2,...), RETURN "ALL < = 4", ELSE RETURN " " (nothing!).
I'm not entirely sure how to do that. Any help or guidance as to how best to do this would be much appreciated.
<tbody>
</tbody>
=IF((AND(ATI2<=4, ATQ2<=4,ATS2<=4,AVV2<=4,AVW2<=4, AWR2<=4,BAF2<=4)), "ALL < = 4", " ")
I am analysing some survey data and I am trying to group a set number of questions together so that I can determine if a patient has rated their pain equal to or below 4 (out of 10) for ALL of the chosen questions. An example of the data is below. As well as the formula I am currently using.
The problem I have noticed is that the formula will show "ALL < = 4" even if NO data is in the cells. Logically this makes sense, but a 0 and blank cell are very different in this respect. What I need is:
IF a number is present AND it is EQUAL to or LESS than 4 in each of these cells (ATI2,ATQ2,...), RETURN "ALL < = 4", ELSE RETURN " " (nothing!).
I'm not entirely sure how to do that. Any help or guidance as to how best to do this would be much appreciated.
| Question C8 | Question C10 | Question C13 | Question C20 | Question C21 | Question C27 | Question C33 | ALL NRS < = 4 |
| 7 | 7 | 7 | 8 | 5 | 9 | 9 | |
| 2 | ALL NRS < = 4 | ||||||
| ALL NRS < = 4 | |||||||
| 3 | 3 | 2 | 0 | ALL NRS < = 4 |
<tbody>
</tbody>
=IF((AND(ATI2<=4, ATQ2<=4,ATS2<=4,AVV2<=4,AVW2<=4, AWR2<=4,BAF2<=4)), "ALL < = 4", " ")
