A1:=V>=REF(V,1)*2 AND C>=REF(C,1)*1.095 AND C>=H;A2:=C>O;A3:=CXG:REF(A1,2) AND REF(A2,1) AND A3;参考资料:http://tieba.baidu.com/f?kw=%E8%82%A1%E7%A5%A8%E5%85%AC%E5%BC%8F%E4%B8%93%E5%AE%B6&ie=utf-8