excel问题,请求高手帮忙谢谢
2003年版Excel,只能套嵌7层是不能变的。 但有变通的方法:
1、如:=IF(LEFT(C9,2)="君越","EU",IF(LEFT(C9,2)="凯越","L",IF(OR(LEFT(C9,2)="君威",LEFT(C9,2)="别克"),"J",IF(LEFT(C9,2)="赛欧","S",IF(OR(LEFT(C9,3)="GL8",LEFT(C9,2)="陆尊"),"D",""))))) &IF(LEFT(C9,2)="君越1","EU1",IF(LEFT(C9,2)="凯越1","L1",IF(OR(LEFT(C9,2)="君威1",LEFT(C9,2)="别克1"),...全部
2003年版Excel,只能套嵌7层是不能变的。
但有变通的方法:
1、如:=IF(LEFT(C9,2)="君越","EU",IF(LEFT(C9,2)="凯越","L",IF(OR(LEFT(C9,2)="君威",LEFT(C9,2)="别克"),"J",IF(LEFT(C9,2)="赛欧","S",IF(OR(LEFT(C9,3)="GL8",LEFT(C9,2)="陆尊"),"D",""))))) &IF(LEFT(C9,2)="君越1","EU1",IF(LEFT(C9,2)="凯越1","L1",IF(OR(LEFT(C9,2)="君威1",LEFT(C9,2)="别克1"),"J1",IF(LEFT(C9,2)="赛欧1","S1",IF(OR(LEFT(C9,3)="GL81",LEFT(C9,2)="陆尊1"),"D1",""))))) ,但字符数不能超过要求;
2、选一空白处(如H列),
将H1输入:
=IF(LEFT(C9,2)="君越","EU",IF(LEFT(C9,2)="凯越","L",IF(OR(LEFT(C9,2)="君威",LEFT(C9,2)="别克"),"J",IF(LEFT(C9,2)="赛欧","S",IF(OR(LEFT(C9,3)="GL8",LEFT(C9,2)="陆尊"),"D","")))));
将H2输入:
IF(LEFT(C9,2)="君越1","EU1",IF(LEFT(C9,2)="凯越1","L1",IF(OR(LEFT(C9,2)="君威1",LEFT(C9,2)="别克1"),"J1",IF(LEFT(C9,2)="赛欧1","S1",IF(OR(LEFT(C9,3)="GL81",LEFT(C9,2)="陆尊1"),"D1","")))))等等;
……
在原先输入公式的地方输入:=H1&H2……
注意,每一个公式必须要返回空值。收起