回复：函数问题你问我答，太难的不会

按原题就太简单了，不过不太实用

=VLOOKUP(G2&H2,IF({1,0},$A$1:$A$5&$B$1:$B$5,$C$1:$C$5),2,0) 数组公式

=EVALUATE(SUBSTITUTE(TEXTJOIN(",",1,A1:D4),",","+")&"+0") WPS直接用 ，Excel要放在名称了

=IF(A1="","",IFERROR("在C列第"&MATCH("*,"&A1&",*",","&$C$1:$C$100001&",",)&"行","没找到"))

百度sumifs ()

一步到位的方法很难，涉及双重迭代计算，写不出了。这里用遍历方，先遍历每个报名价会对应什么到手价。建成一个辅助表。然后就可以用vlookup 或match index来找出对应的报名价

=MIN(IF((J5+{20,50,100,150}+(ROW($1:$30)-1)*15)-LOOKUP((J5+{20,50,100,150}+(ROW($1:$30)-1)*15),{0;549;699;799},{20;50;100;150})-INT((J5+{20,50,100,150}+(ROW($1:$30)-1)*15)/200)*15=J5,J5+{20,50,100,150}+(ROW($1:$30)-1)*15,"")) 数组3键

=LOOKUP(1,0/(($A$2:$A$12=H4)*$B$2:$B$12=MAX(($A$2:$A$12=H4)*$B$2:$B$12)),$C$2:$C$12) 数组3键

=IF(COUNT(FIND("B",C2)),"C",IF(COUNT(FIND("E",C2)),"F",""))

圈中的）都放到最后