CLNG;求和错误“Type MisMatch” [英] Clng; Sum error "Type MisMatch"

问题描述

我已经尝试了这个字符串来汇总付款，移动括号和paren'的不同方式，我仍然得到错误''类型不匹配''......不知道为什么。谁能指出我正确的方向？谢谢

I''ve tried this string to Sum up payments, moving brackets and paren''s different ways, I still get error ''type mismatch''....not sure why. Can anyone point me in the right direction?? thanks

展开 | 选择 | Wrap | 行号

推荐答案

我已经尝试了这个字符串来汇总付款，移动括号和paren'的不同方式，我仍然得到错误''类型不匹配''......不知道为什么。谁能指出我正确的方向？谢谢

I''ve tried this string to Sum up payments, moving brackets and paren''s different ways, I still get error ''type mismatch''....not sure why. Can anyone point me in the right direction?? thanks

展开 | 选择 | Wrap | 行号

我已经尝试了这个字符串来汇总付款，移动括号和paren'的不同方式，我仍然得到错误''类型不匹配''......不知道为什么。谁能指出我正确的方向？谢谢

I''ve tried this string to Sum up payments, moving brackets and paren''s different ways, I still get error ''type mismatch''....not sure why. Can anyone point me in the right direction?? thanks

展开 | 选择 | Wrap | 行号

BTW [数量] * [UnitPrice] *（1- [折扣]）在[折扣]> 1

BTW [Quantity]*[UnitPrice]*(1-[Discount]) will be negative when [Discount]>1

时将为负数我的猜测是[折扣] ]是十进制形式的百分比所以它可能永远不会大于1.但我不能代表imrosie，所以我可能是错的

My guess is that [Discount] is a percentage in decimal form so it probably won''t ever be greater than 1. But I can''t speak for imrosie, so I could be wrong

这篇关于CLNG;求和错误“Type MisMatch”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！