if(h4="总店经营部"&&m4>=10^8,"一档",if(h4="总店经营部"&&m4>=6*10^7,"二档",if(h4="总店经营部"&&m4>=2*10^7,"三档",f(h4="总店经营部"&&m4<2*10^7,"四档",if(h4="连锁一部"&&m4>=5*10^7,"一档",if(h4="连锁一部"&&m4>=2*10^7,"二档"

----------------------------------------------------------

------------------------我是分隔符号--------------------------------

按上面的格式自己补充完整吧。。。

补充完整的

if(h4="总店经营部"&&m4>=10^8,"一档",if(h4="总店经营部"&&m4>=6*10^7,"二档",if(h4="总店经营部"&&m4>=2*10^7,"三档",f(h4="总店经营部"&&m4<2*10^7,"四档",if(h4="连锁一部"&&m4>=5*10^7,"一档",

if(h4="连锁一部"&&m4>=2*10^7,"二档",if(h4="连锁一部"&&m4>=8*10^6,"三档",if(h4="连锁一部"&&m4>8*10^6,"四档",

if(h4="连锁二部"&&m4>=2*10^7,"一档",if(h4="连锁二部"&&m4>=5*10^6,"二档",if(h4="连锁二部"&&m4>=2*10^6,"三档","四档")))))))))))

多源报表实现数据过滤

汇总求和