excel 求大神出马 多条件计算函数或公式 A1类别 B1重量 C1是要算出来...答:C2输入=IF(AND(RIGHT(A3,2)="钻石",B3<1),800,IF(AND(RIGHT(A3,2)="钻石",B3>1),(B3-1)*600+800,IF(AND(RIGHT(A3,2)="宝石",B3<1),600,IF(AND(RIGHT(A3,2)="宝石",B3>1),(B3-1)*400+600,IF(AND(RIGHT(A3,2)="玛瑙",B3<1),350,IF(AND(RIGHT(A3,2)="玛瑙",...