Excel表格中多列条件,多种组合,怎么显示不同结果?答:F3 =IF(COUNTIF(C3:E3,"否")=3,"一无是处",IF(C3="是","聪明","不聪明")&IF(D3="是","健康","体弱")&IF(E3="是","孝顺","不孝顺"))
EXCEL 多种选项条件对应多个结果 怎么用VBA解决?答:首先打开excel,按alt+f11,打开vba编辑器,然后插入一个模块,模块内容如下,你照抄过去 Sub A()Dim A#, B#, C#, D#, E#, F#, G#, H#, I#, M#, X#Dim Hang As LongFor Hang = 2 To Range("a1").End(xlDown).Row Step 3 A = Cells(Hang, 1): B = Cells(Hang, 2)...