求excel函数高手给个答案.某数据具有3个分类特征A,B,C,如果想用excel进行分类A>5.5*B>5.5*C>5.5时为特征一A>5.5*B>5.5*C5.5*B5.5时为特征五A>5.5*B

Question

求excel函数高手给个答案.某数据具有3个分类特征A,B,C,如果想用excel进行分类
A>5.5*B>5.5*C>5.5时为特征一
A>5.5*B>5.5*C5.5*B5.5时为特征五
A>5.5*B

Answer 1

=CHOOSE(MATCH(SUMPRODUCT((A1:C1>5.5)*{1,10,100}),{111,11,10,110,101,1,100,0},0),"特征一","特征二","特征三","特征四","特征五","特征六","特征七","特征八")
特征七写错了,应该是A