主题：[求助]用什么函数语句，可以是小数变成百分数，多谢了！

如果您的公式是刷新公式，请选中该列的任一单元格，执行菜单命令的do(87)命令即可，公式是您原来的公式不变（列类型必须是数字型）：
    CountFor("业务酒水","酒水类别"," = ","白酒") / (CountFor("业务酒水","酒水类别"," = ","白酒") + CountFor("业务酒水","酒水类别"," = ","果酒") + CountFor("业务酒水","酒水类别"," = ","啤酒") + CountFor("业务酒水","酒水类别"," = ","黄酒") + CountFor("业务酒水","酒水类别"," = ","饮料"))

     如果该刷新公式列类型是字符型，公式改为：
     text(CountFor("业务酒水","酒水类别"," = ","白酒") / (CountFor("业务酒水","酒水类别"," = ","白酒") + CountFor("业务酒水","酒水类别"," = ","果酒") + CountFor("业务酒水","酒水类别"," = ","啤酒") + CountFor("业务酒水","酒水类别"," = ","黄酒") + CountFor("业务酒水","酒水类别"," = ","饮料"))*100)+"%"

       您试试看！

egd文件下载

     原因是CountFor()函数返回的值应该是字符型，无法直接参与计算！
     
     另外，我把按钮公式放在了打开窗口前执行公式中，所以打开该窗口即显示结果，只有在修改了表数据时，再使用按钮，使别人看不到您的标签的原始字符！

egd文件下载

      楼上的文件有个小小的弊病，百分比数未经过四舍五入处理，会出现多位小数甚至无限不循环小数，现加以修改，统一精确到两位小数（见本楼文件）

[这个贴子最后由程兴刚在 2007/06/23 00:57pm 第 1 次编辑]

       呵呵，太客气了，相互帮助，相互学习嘛，有事尽管说，我定尽其所能！