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”)
Hi Twifoo
Many thanks for your help, much simpler than my way, but comes back with a #value!
I am guessing that, that because although looking at X3-AC3, it is not looking for a True or False statement against them. In this case, True would mean that if any one of the X3 to AC3 are true, then that would =No Risk, and a false to X3 to AC3 would = Risk
Try this:
=IF(ISBLANK(C3)+X3+Y3+Z3+AA3+AB3+AC3,
“No Risk”,
Risk”)
=IF(ISBLANK(C3)+X3+Y3+Z3+AA3+AB3+AC3,
“No Risk”,
Risk”)