Hello,
I have a program that identifies a product that is being used. If the conditions are met, then it will take the unit cost of each component of the finished good and adds it up and adds it to the finished good - giving the Finished Good it's respective unit cost.
I'm having a problem adding up the values of the components. How do I get the sum of all of the loops? Here's the code, I included comments on the relevant code:
Please Login or Register to view this content.
Your code is unclear. It would be more clear if you added the .Value property rather than relying on the default property to be used.
You set the data type for YU to be integer. Maybe you should have used Long or even Double if you have decimal values.
At a quick glance... to keep adding to YU, how about instead of
usePlease Login or Register to view this content.As kenneth pointed out, integer has a relatively low maximum (32,767 in Excel 2010, while Long data type goes past 2 billion.), so depending on the total, you may need to change the data typePlease Login or Register to view this content.
Last edited by Arkadi; 11-04-2016 at 01:46 PM.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Thanks everyone. Your suggestions helped immensely.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks