I have an easy one I think but am having trouble.
I am working on a spreadsheet to calculate how many parts someone needs to order to reach a $500 minimum. I have the sell price and the quantity per bag. The qty per bag can change, varying from 25 pcs to 2500 pcs. So, I've got the minimum number of pieces they need to order. I just need to figure out how to round that number up so it is incremental of the bag qty. Example: Price is $.055 each. There is a $500 minimum. Bag qty is 100 (but could be 1000). It calculates it as 9090. I need it to calculate it to round to 9100.
I am working on a spreadsheet to calculate how many parts someone needs to order to reach a $500 minimum. I have the sell price and the quantity per bag. The qty per bag can change, varying from 25 pcs to 2500 pcs. So, I've got the minimum number of pieces they need to order. I just need to figure out how to round that number up so it is incremental of the bag qty. Example: Price is $.055 each. There is a $500 minimum. Bag qty is 100 (but could be 1000). It calculates it as 9090. I need it to calculate it to round to 9100.