ExcelBanter - Package Quanity Moves Help with formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Package Quanity Moves Help with formulas (https://www.excelbanter.com/excel-worksheet-functions/243624-package-quanity-moves-help-formulas.html)

VictorKulikowski

Package Quanity Moves Help with formulas

I am moving lots of inventory and need help with excel function to help me
decide if it is better to move it or leave it behind according to the case
quantity.
Cell A1 is inventory I have on hand
Cell B1 is the package quantity
In theory I would like to move 75 of these units and leave 10 behind.
A B
1 85 25

Mike H

Package Quanity Moves Help with formulas

Maybe

=MOD(A1,B1)

Mike

"VictorKulikowski" wrote:

I am moving lots of inventory and need help with excel function to help me
decide if it is better to move it or leave it behind according to the case
quantity.
Cell A1 is inventory I have on hand
Cell B1 is the package quantity
In theory I would like to move 75 of these units and leave 10 behind.
A B
1 85 25

All times are GMT +1. The time now is 05:21 PM.