what % of # of people that pass were not taking it for the first time
To find what percentage of number of people that pass that were not taking it for the first time, you must use the array forumla: =SUM(IF(CANDIDATES=FIRST TIME,IF(CANDIDATES=PASS,1,0),0))/COUNTIF(CANDIDATES,FIRST TIME) You can also use boolean logic instead to write this formula: =SUM((CANDIDATES=FIRST TIME)*(CANDIDATES=PASS)*1)/COUNTIF(CANDIDATES,FIRST TIME) Hope this helps!
nested IF statements!!! i suck at those. nice job.
looks more like a recursive if statement
Passed in one go, but barelt could believe the outcome!