excel中if套用出现您为此函数输入太多参数

日期：2012-07-15 06:44:03 人气：1

=IF(U3<=1,1,IF(U3=$AA$8,IF(10<=T3<=19.9,$AB$8,(IF(20<=T3<=29.9,$AC$8,IF(30<=T3<=39.9,$AD$8,$AE$8)))),TREND(OFFSET(IF(10<=T3<=19.9,$AB$8,IF(20<=T3<=29.9,$AC$8,IF(30<=T3<=39.9,$AD$8,$AE$8))),MATCH(U3,$AA$3:$AA$8),,2),O