Calculation based on multiples
Solved
thibaut
-
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Hello,
To help me with the verification of pallet preparation, I want to automate the calculation.
My table includes the product reference, the number of bottles, the number of cartons (bottles/6), and the total number of cartons.
My issue starts here: I can put 14 cartons on one layer.
I divided my total number of cartons by 14 and then used the truncate formula to get the number of layers.
However, I can't find a formula that would allow me to automate the calculation of unfinished layers (by manually retrieving the data from a second table which is a multiplication table of 14, I manage to do it).
Thank you
Configuration: Windows / Opera Next 43.0.2442.806
To help me with the verification of pallet preparation, I want to automate the calculation.
My table includes the product reference, the number of bottles, the number of cartons (bottles/6), and the total number of cartons.
My issue starts here: I can put 14 cartons on one layer.
I divided my total number of cartons by 14 and then used the truncate formula to get the number of layers.
However, I can't find a formula that would allow me to automate the calculation of unfinished layers (by manually retrieving the data from a second table which is a multiplication table of 14, I manage to do it).
Thank you
Configuration: Windows / Opera Next 43.0.2442.806
3 answers
-
Hello
Not too sure...
What is the number of unfinished layers?
By dividing the number of boxes by 14, there are only two options apparently
either the number is a multiple of 14 and there are no unfinished layers
or it is not a multiple and there can only be one layer?
However, to find the number of boxes in the unfinished layers:
=MOD(cell;14)
But to go further, you would need to tell us more
Best regards
--
The quality of the answer mainly depends on the clarity of the question, thank you! -
Good evening
For the layers, I put on 8 or 9 at most
After that, I'm not very good at math.
My idea was that for my check, I could tell myself at some point
I have 3 layers and 10 boxes for example.
But with the mod function, it seems really good to me. What is this function please? -
