EXCEL IF AND 嵌套超过7层怎么处理啊,具体见下面答:最好改用其它函数,如LOOKUP、VLOOKUP等,用IF变通一下也行,将多个6层以下的嵌套相加,公式如下:=IF(AND(C6>0,C6<=2),3,IF(C6>2,1.5,IF(C6>8,0.7,IF(C6>19,1,IF(AND(C6>29,C6<=80),1.6,0)))+IF(C6>80,1.7,IF(C6>100,2.4,IF(C6>150,3.2,IF(C6>200,4,0)))...
Excel如何用函数统计人数,出现多次只算一人?答:=多项查询($C:$C,$B:$B,E$17,,2)'自定义公式-按ALT+F11-插入-模块-粘贴代码-将表格另存为启用宏的格式 Function 多项查询(a As Range, b As Range, c As String, Optional ByVal fgf As String = "|", Optional ByVal 模式 As String = 1)If a.Cells(3, 1) <> "" Then ...