Question

一个关于表格公式的问题.求EXCEL大神告知

Answer 1

=if(A1="a",XX+X,ifA1="b",XX+XX,if(A1="c",XX*XX,"")))

IF不能套太多,建议用LOOKUP来写, 最好是把你所有的内容截图上来.

=LOOKUP("C",{"a","b","c","d";1,2,3,4})

=LOOKUP("bump",{"a",1;"b",2;"c",3})