《Excel-电子表格制作案例教程》家电销售表(函数).xlsx

洁豪电器家电销售情况表序号销售部门产品名称产品型号折扣销售单价JH0001A部彩电SM-5EGT95%￥2,180.50JH0002C部彩电HR-OKK1-598%￥2,298.00JH0003B部彩电SM-5EGT98%￥2,180.00JH0004A部空调HV-1100S1.097%￥1,680.50JH0005B部空调HV-1100S1.095%￥1,680.50JH0006B部空调HV-1100S1.097%￥1,680.50JH0007A部冰箱HR-OKK1-598%￥2,300.00JH0008C部冰箱SM-5EGT95%￥2,200.00JH0009C部冰箱HR-OKK1-597%￥2,300.00JH0010B部彩电SM-5EGT98%￥2,080.00JH0011B部彩电SM-5EGT97%￥2,100.50JH0012C部彩电SM-5EGT95%￥2,100.50JH0013A部空调HV-1100S1.097%￥1,680.00JH0014A部空调HV-1100S1.098%￥1,680.00JH0015C部空调HV-1100S1.095%￥1,680.00JH0016B部冰箱HR-OKK1-595%￥2,298.00JH0017A部冰箱HR-OKK1-598%￥2,298.00JH0018C部冰箱HR-OKK1-595%￥2,280.00JH0019B部彩电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￥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