我应该使用哪种数据类型在Excel Vba中传递0.08 1/2 [英] Which Data Type should i use to pass 0.08 1/2 in Excel Vba

问题描述

大家好，
我有一个任务，即我需要计算获得收入的客户份额.公司有20个合作伙伴，总份额为104.一个合作伙伴的份额为0.08 1/2，我将其份额作为Double发挥作用.但是遇到错误时，任何人都可以告诉我应该使用哪种数据类型来传递Excel Vba中的值

谢谢，
MOHAMMAD SIDDIQALI.

Hi to all,
I have a task i.e i need to calculate the client share with received income.Company have 20 partners and with total shares of 104.One of the partner have with share of 0.08 1/2 and i am passing his share as Double to function.But getting error can any one tell which data type should i use to pass the value in Excel Vba

Thanks,
MOHAMMAD SIDDIQALI.

推荐答案

0.08 1/2是什么意思?这不是正确的数值.如果1/2表示一半，则只需将其加5即可自己翻译.然后将变为0.085.您不能通过它奇怪的公式.

祝你好运！

What do you mean with 0.08 1/2? This isn''t a correct numeric value. If the 1/2 means a half then simply translate it yourself by simply adding 5 to it. This would then become 0.085. You can''t pass it strange formula''s.

Good luck!

这篇关于我应该使用哪种数据类型在Excel Vba中传递0.08 1/2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！