>>/6552/
> Pls give the formula for rounding to 0.25lbs, you're the math wizard!
=IF(QUANTITY="", "", ROUND(QUANTITY*WEIGHT*4,0)/4)
This formula does as it says, it checks if there is an item, if there is no quantity, there is no weight, [""] counts as blank or zero but does not display a [0].
- Furthermore, it multiplies the quantity by the weight of each and multiplies that by 4 and rounds it.
- This will make something that weighs less than .125 become zero and something that weighs .125 or greater count as 1 lb as a group.
- If there is 1 item at .25lbs, it will count as 1lb at this point.
- Lastly it divides the result by 4 such that it will make sure the result is a multiple of .25, hence an item that weighs .25 will count as .25, something that weighs .2 will also count as .25 etc.
Doing this, we saved a few lbs in Bear's group's inventory.