Need help on IF function........

  • Thread starter Thread starter wind
  • Start date Start date
W

wind

Hi guys. I have a survey which users must answer Y/N (5 questions in
cell L8 to L12).
- If all 5 are "N", cell L15 will show "Not tested".
- If 1 question or more are "Y", cell L15 will show "tested".
- If any questions are left blank, cell L15 will show "survey not
completed"
- Even 1 question or more are "Y", but survey is not completed, cell
L15 will still show "survey not completed".

How can this be achieved? Can u guys enlighten? Also, i'm a total
newbie in vba and excel functions. Where would be a good place to start
learning. Any free resources available on the web? thks. :)
 
Wind

You will need to use an Array formula.


Copy and paste the following formula into the formula bar then pres
Ctrl + Shift + Enter keys


=IF(SUM(IF(L8:L12<>"",1,0))<5,"survey no
completed",IF(SUM(IF(L8:L12="y",1,0))=5,"tested","not tested")
 
Name your L8:L12 range "answers", or replace the "answers" range in the
formula with your range............

=IF(COUNTA(answers)<5,"Survey not complete",IF(COUNTIF(answers,"N")=5,"Not
tested",IF(COUNTIF(answers,"Y")>0,"Tested","")))

Vaya con Dios
Chuck, CABGx3
 
Back
Top