獎勵金前 3名 一條件排除 (12825)

E2{=IFERROR(LOOKUP(1,0/(LARGE(IF(C$2:C$16=0,B$2:B$16),{1,2,3})=B2)/(C2=0),{1000,800,500}),"")

另解{=IFERROR(LOOKUP(1,0/(D2=SMALL(IF(C$2:C$16=0,D$2:D$16,99),ROW($1:$3)))/(C4=0),{1000;800;500}),"")

另解=LOOKUP(COUNTIFS(B:B,">="&B2,C:C,"")*(C2=0),{0,1,2,3,4},{"",1000,800,500,""})

另解=LOOKUP(SUMPRODUCT((C$2:C$16="")*(B$2:B$16>=B2))*(C2=0),{0,1,2,3,4},{"",1000,800,500,""})