Forum Discussion
Solved
Use Excel to perform my data interpration
Hi, I have been performing this Data Interpretation on my own and I would like to use Excel to automatically perform this data analysis for me if possible: There are 8 possible scenarios and 4 diffe...
=IF(AND(COUNTIF(B2:D2,"Abs")=3,E2="Pres"),"Negative",IF(AND(COUNTIF(B2:D2,"Pres")<=1,E2="Abs"),"Invalid",IF(COUNTIF(B2:D2,"Pres")>=2,"COVID-19 Pos",IF(AND(COUNTIF(B2:D2,"Pres")=1,E2="Pres"),"Indeterminate",""))))
You can try a nested IF formula.
=IF(AND(COUNTIF(B2:D2,"Abs")=3,E2="Pres"),"Negative",IF(AND(COUNTIF(B2:D2,"Pres")<=1,E2="Abs"),"Invalid",IF(COUNTIF(B2:D2,"Pres")>=2,"COVID-19 Pos",IF(AND(COUNTIF(B2:D2,"Pres")=1,E2="Pres"),"Indeterminate",""))))
You can try a nested IF formula.
- Thank you so much for this nested if formula it worked beautifully!