G2=3时,H2提成多少?假设是0H4=E4*LOOKUP(1,0/(G4>{0,3,4,5,6,7,9}),{0,3,4,5,6,7,10}%)下拉
=LOOKUP(G4,{0,3,4,5,6,7,9},{0,3,4,5,6,7,10}%)