导读 =收银额/日均销售*(日均销售*HLOOKUP(日均销售,{0,5001,10001,20001;0.007,0.004,0.003,0.002},2,1)+5000*HLOOKUP(日均销售,{0,5001,10001,...
=收银额/日均销售*(日均销售*HLOOKUP(日均销售,{0,5001,10001,20001;0.007,0.004,0.003,0.002},2,1)+5000*HLOOKUP(日均销售,{0,5001,10001,20001;0,0.003,0.005,0.01},2,1))呵呵，不难的东西呀，也费了我好一阵功夫才弄出来的。
总算弄出来了，水平还有待有提高，学习EXCEL 中。