Hi everyone. I'm in need of a little excel help.
I have to work out a formula that uses two lots of numbers to give a final figure (whilst rounding down to a complete value and not leaving a decimal).
For example:
In order to create Product A, it requires 8 parts of Ingredient A and 1 part of Ingredient B.
The result of the formula:
If I have 16 parts of Ingredient A and 2 parts of Ingredient B, the formula should identify that I can create Product A twice.
If I have 18 parts of Ingredient A and 5 parts of Ingredient B, the formula should identify that I can still create Product A only twice without leaving a decimal remainder.
The other thing in which I'm having trouble with is creating sortable fields from the header that you can click to sort (I'm not sure if that makes sense, can expand upon it further if necessary).
Any help would be immensely appreciated.
Bookmarks