=IF(AND(K7={5,6,7,8,9},F7>60),"0.6",IF(AND
(K7={5,6,7,8,9},40<F7<=60,"0.7",IF(AND(K7=
{5,6,7,8,9},20<F7<=40,"0.8",IF(AND(K7=
{5,6,7,8,9},F7<=20,"1.2",IF(AND(K7=
{3,4,10,11},F7>60,"0.3",IF(AND(K7=
{3,4,10,11},40<F7<=60,"0.35",IF(AND(K7=
{3,4,10,11},20<F7<=40,"0.4",IF(AND(K7=
{3,4,10,11},F7<=20,"0.6",0))))))))
我想输入F列和K列输入后,可自动计算出空调系数。
也不对
我是2013的版本
追答我试了一下,是你的公式有问题,好好找找公式的错误吧