Forum Discussion
Solved
=IF Function, I think
So here is my problem, lets start with what i have; =COUNTIF(C3,">"""),IF(AND(X3=FALSE,Y3=FALSE,Z3=FALSE,AA3=FALSE,AB3=FALSE,AC3=FALSE),"Risk",IF(AND(X3=TRUE,Y3=TRUE,Z3=TRUE,AA3=TRUE,AB3=TRUE,AC3=TR...
- Try this:
=IF((C3="")+SUMPRODUCT(--X3:AC3),
“No Risk”,
“Risk”)
Hello Andy,
I guess that this is what you need:
=IF(C3=“”+X3+Y3+Z3+AA3+AB3+AC3,
“No Risk”,
“Risk”)
I guess that this is what you need:
=IF(C3=“”+X3+Y3+Z3+AA3+AB3+AC3,
“No Risk”,
“Risk”)