洁豪电器家电销售情况表序号销售部门产品名称产品型号折扣销售单价
JH0001A部彩电SM-5EGT95%￥2,180.50 JH0002C部彩电HR-OKK1-598%￥2,298.00 JH0003B部彩电SM-5EGT98%￥2,180.00 JH0004A部空调HV-1100S1.097%￥1,680.50 JH0005B部空调HV-1100S1.095%￥1,680.50 JH0006B部空调HV-1100S1.097%￥1,680.50 JH0007A部冰箱HR-OKK1-598%￥2,300.00 JH0008C部冰箱SM-5EGT95%￥2,200.00 JH0009C部冰箱HR-OKK1-597%￥2,300.00 JH0010B部彩电SM-5EGT98%￥2,080.00 JH0011B部彩电SM-5EGT97%￥2,100.50 JH0012C部彩电SM-5EGT95%￥2,100.50 JH0013A部空调HV-1100S1.097%￥1,680.00 JH0014A部空调HV-1100S1.098%￥1,680.00 JH0015C部空调HV-1100S1.095%￥1,680.00 JH0016B部冰箱HR-OKK1-595%￥2,298.00 JH0017A部冰箱HR-OKK1-598%￥2,298.00 JH0018C部冰箱HR-OKK1-595%￥2,280.00 JH0019B部彩电SM-5EGT95%￥2,080.00
折扣最大值98%
销售额最小值￥193,980.12
制表日期：2011/8/2813:54:00
表
销售数量销售额
￥158.00￥327,293.05
￥175.00￥394,107.00
￥225.00￥480,690.00
￥136.00￥221,691.56
￥248.00￥395,925.80
￥119.00￥193,980.12
￥234.00￥527,436.00
￥228.00￥476,520.00
表格制作excel教程函数
￥124.00￥276,644.00
￥201.00￥409,718.40
￥215.00￥438,059.28
￥228.00￥454,968.30
￥145.00￥236,292.00
￥162.00￥266,716.80
￥148.00￥236,208.00
￥241.00￥526,127.10
￥301.00￥677,864.04
￥157.00￥340,062.00
￥186.00￥367,536.00