PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Become a Premium Member and unlock a new, free course in leading technologies each month.
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Function RodsNeeded(rQty As Range, rLen As Range) As Integer
RodsNeeded = rQty * rLen / 96
End Function
You can not work with the total length, you have to get the pieces per rod first.You are correct! I didn't think about that, but your formula given 8 pieces of length 49 returns 0.
Function RodsNeeded(rQty As Range, rLen As Range) As Integer
Dim intBoltsPerRod As Integer
intBoltsPerRod = 96 \ rLen
RodsNeeded = rQty * intBoltsPerRod
End Function
Private Sub Test()
Const QTY = 8
Const LENGTH = 49
Dim intBoltsPerRod As Integer
intBoltsPerRod = 96 \ LENGTH
MsgBox QTY * intBoltsPerRod ' ==> 8
End Sub
If you are experiencing a similar issue, please ask a related question
Title | # Comments | Views | Activity |
---|---|---|---|
drag and drop a row in excel 2010 | 5 | 45 | |
Changing a formula to reference a cell instead of a static pivot table reference | 12 | 27 | |
VBA to toggle change the excel table structured reference to explicit cell references | 3 | 17 | |
Need to count the pair | 35 | 23 |
Join the community of 500,000 technology professionals and ask your questions.