what % of # of people that pass

CFA Level II
#1

what % of # of people that pass were not taking it for the first time

#2

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!

#3

nested IF statements!!! i suck at those. nice job.

#4

looks more like a recursive if statement

#5

Passed in one go, but barelt could believe the outcome!