IS this number divisible by that number

[bobgrand]

Hello all and Happy Holidays,

You can probably add this to the crazy question list.

Does anyone have a trick up their sleeve to identify if the order quantity of order points are divisible by the package size qty. We have a lot of broken values and I am just trying to find a broad brush way to find these errors.

Example 1: Order points are 20 / 60 and the Package size is 15 - When our inventory reaches 20 we would order 60. The pack qty is 15. (60 is divisible by 15) The answer I would like to appear for this scenario is YES.
Example 2: Order points are 20 / 50 and the Package size is 15 - When our inventory reaches 20 we would order 50. The pack qty is 15. (50 is not divisible by 15) The answer I would like to appear for this scenario is NO.

Please let me know if I am just completely out of my mind.

Thank you
Bob

 

[awoohaw]

Use the MOD() formula.
for 20/60, the formula would be =MOD(60,20)=0, this will result in TRUE
for 20/50 the formula would be =MOD(50,20)=0, this will result in FALSE.

 

[johnny51981]

Another option

=IF([Order Count]/[Package Size])=ROUND([Order Count]/[Package Size],0),"YES","NO")

 

[awoohaw]

@bobgrand ,
my first suggestion was not correct. I read the question poorly.
Here is a corrected mini worksheet of what I was thinking you should do:

Book2
	A	B	C	D	E
1	Order Point	Order Amount	Package Size / Base Mod	Mod Zero
2	10	50	15	No	=IF(MOD(B2,C2)=0,"Yes","No")
3	20	50	15	No	=IF(MOD(B3,C3)=0,"Yes","No")
4	30	50	15	No	=IF(MOD(B4,C4)=0,"Yes","No")
5	40	50	15	No	=IF(MOD(B5,C5)=0,"Yes","No")
6	10	60	15	Yes	=IF(MOD(B6,C6)=0,"Yes","No")
7	20	60	15	Yes	=IF(MOD(B7,C7)=0,"Yes","No")
8	30	60	15	Yes	=IF(MOD(B8,C8)=0,"Yes","No")
9	40	60	15	Yes	=IF(MOD(B9,C9)=0,"Yes","No")
10	50	60	15	Yes	=IF(MOD(B10,C10)=0,"Yes","No")
Sheet3

Cell Formulas
Range	Formula
D2:D10	D2	=IF(MOD(B2,C2)=0,"Yes","No")
E2:E10	E2	=FORMULATEXT(D2)