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

成本/售价
范例：25/50=0.5      目的想让0.5变成50%
上述计算结果是小数，如何让计算结果变成百分数，用什么函数语句。
请高手帮忙，多谢了！

Format(25/50,"0.00%")

-=-=-=- 以下内容由 ruizhi813 在 2007年06月22日 08:06pm 时添加 -=-=-=-
Format(25/50,"0%")

ruizhi813，感谢你的帮助。
可是我套用你给我的函数语句，我下面的实际公式确不行，望指教。

format(CountFor("业务酒水","酒水类别"," = ","白酒") / (CountFor("业务酒水","酒水类别"," = ","白酒") + CountFor("业务酒水","酒水类别"," = ","果酒") + CountFor("业务酒水","酒水类别"," = ","啤酒") + CountFor("业务酒水","酒水类别"," = ","黄酒") + CountFor("业务酒水","酒水类别"," = ","饮料")),"0.00%")

将CountFor("业务酒水","酒水类别"," = ","白酒") / (CountFor("业务酒水","酒水类别"," = ","白酒") + CountFor("业务酒水","酒水类别"," = ","果酒") + CountFor("业务酒水","酒水类别"," = ","啤酒") + CountFor("业务酒水","酒水类别"," = ","黄酒") + CountFor("业务酒水","酒水类别"," = ","饮料"))用变量代替试试

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

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

       您试试看！

总版主   程兴刚    二位高手：
感谢你们的帮助，我使用了你们给我的建议，但是还是不行。我把实际例表传上来了，麻烦你们给看看，问题出在哪里。多谢了！！！egd文件下载

egd文件下载

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

egd文件下载

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

程兴刚 兄长：
我昨晚发出的求助问题，今早刚到单位就看到了你给我的解决方案，你的解决方案太完美了，连一些细小的地方都给我提出了建议，使我所编的程序更加完美了，我衷心的感谢你！！！
或许今后还会给您添麻烦，望您不吝赐教。

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

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