I have a product with 40 rolls that makes up a carton, if I have 2.13+2.25+3.19, ordinarily it will give me 7.57, How can I convert 2.13+2.25+3.19 = 7.57 to 8.17, since every 0.40 equal to 1
I have a product with 40 rolls that makes up a carton, if I have 2.13+2.25+3.19, ordinarily it will give me 7.57, How can I convert 2.13+2.25+3.19 = 7.57 to 8.17, since every 0.40 equal to 1
Welcome to the forum.
Can you explain that all again, a little slower?
Entia non sunt multiplicanda sine necessitate
In a given product, I have 40 packs in a carton. That is, every 40 packs equals 1 carton.Then, cell A2 = 2.13 which is 2cartons 13packs, B2 = 2.25 which is 2cartons 25packs,C2 = 3.19 which is 3cartons 19packs.
The summation of A2+B2+C2 (i.e 2.13+2.25+3.19) = 7.57 (i.e 7cartons 57packs). Since every 40packs is rounded up to 1Carton, I am suppose to get 8.17 as my answer and not 7.57. How can I round up every decimal that is up to 0.40 to 1
If using XL2007 as implied one possibility:
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Wow! that's it. Thanks
You could shorten that to the following:
=DOLLARFR(SUMPRODUCT(DOLLARDE(A2:C2+0,40)),40)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks