新人求救！

只要IF 和 +号就够了 和VLOOKUP什么关系？

=IF(AND(B3-B12>0,B3-B12<50),B3*C3*3%,IF(AND(B3-B12>=50,B3-B12<100),B3*C3*5%,IF(B3-B12>=100,B3*C3*10%,0)))+IF(AND(D3-D12>0,D3-D12<50),D3*E3*3%,IF(AND(D3-D12>=50,D3-D12<100),D3*E3*5%,IF(D3-D12>=100,D3*E3*10%,0)))+IF(AND(F3-F12>0,F3-F12<50),F3*G3*3%,IF(AND(F3-F12>=50,F3-F12<100),F3*G3*5%,IF(F3-F12>=100,F3*G3*10%,0)))+IF(AND(H3-H12>0,H3-H12<50),H3*I3*3%,IF(AND(H3-H12>=50,H3-H12<100),H3*I3*5%,IF(H3-H12>=100,H3*I3*10%,0)))