IF formula returns error; abbreviating the formula
Try this...
=IF(COUNTIF(V40:V42,"No"),"Fail",IF(COUNTIF(V40:V4 2,"Yes")=3,"Pass",""))
--
Biff
Microsoft Excel MVP
"MZ" wrote in message
...
I used the following formula to evaluate the "Yes/No" responses to several
questions.
If any of the responses are "No" then the formula should return "Fail";
only
if all are "Yes", then it should return "Pass"
=IF(OR(V40,V41:V42)="No","Fail","Pass")
V40, V41, and V42 are the cells that contain the Yes/No responses
The formula returned an error.
Any suggestions for correction?
In addition, if there are many questions, how would I abbreviate the query
of cells so that I do not manually list them, as I did above - i.e.
instead
of V40,V41,V42, use something like a colon between the first and last
cell -
V40:V42?
Thank you
--
MZ
|